"fields:" Parameter Misbehaving

PaulM1
New Member

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?

0 0 45
0 REPLIES 0
Top Labels in this Space
Top Solution Authors