I have this very simple scenario. Here is the View:
view: Customer {
sql_table_name: "DBO"."CUSTOMER" ;;
dimension: id {
primary_key: yes
type: number
sql: ${TABLE}."id" ;;
}
dimension: customer_name {
type: string
sql: ${TABLE}."customer_name" ;;
}
}
Here is the Model:
connection: "sandbox01"
label: "Sandbox - Model A"
include: "/**/*.view.lkml"
explore: Customers {
label: "Explore Customers"
from: Customer
fields: [
customer_name
]
}
When I go to the Explore, there are no fields in the field list. Shouldn’t ‘customer_name’ be available in the field list?
If I change the fields: parameter to “ALL_FIELDS*” (or completely omit the fields: parameter) it behaves as expected. And if I change it to “customer_name,id” it still does not show any fields in the Explore’s field list.
Am I missing something?