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

Knowledge Drop

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.                

 

Version history
Last update:
‎05-07-2021 09:00 AM
Updated by: