Knowledge Drop

Why is my NDT showing a "No such field ' ' in source explore ' ' " error?


Userlevel 5

Last tested: Mar 14, 2018

 

This has been shown to happen to NDTs for 2 main reasons. One is a Typo in the view_name.field_name reference and the other reason is a missing fully scoped field reference.

Typo in field name

Error Message:

A LookML model issue occurred.
No such field "produtypo.category" in source explore "order_items"
bucket1/ndttest.view.lkml:4

 

NDT LookML:

view: ndttest {

derived_table: {

explore_source: order_items {

column: category { field: produtypo.category }

column: count { field: products.count }


Where there is a typo at productypo and that should be products


Missing Full Scoped Field reference

Error Message:

A LookML model issue occurred.
No such field "category" in source explore "order_items"
bucket1/ndttest.view.lkml:4

 

NDT LookML:

view: ndttest {

derived_table: {

explore_source: order_items {

column: category { field: category }

column: count { field: products.count }

 

 

Where field: category should be written fully scoped as field: products.category
 

 

This content is subject to limited support.                

 

 


0 replies

Be the first to reply!

Reply