LookML error: could not find a field 'nbfc_name'

Here is the code snippet. I m unable to figure out why it throws this error even when the field is present.

 

 

view: number_of_txns {
derived_table: {
sql:
SELECT t.nbfc_name as nbfc_name,
t.partner_name as partner_name,
t.updated_at AS updated_at,
t.id AS id
FROM `abc.t`
;;
}

measure: disbursed_loans {
type: count_distinct
sql: ${TABLE}.id
}

dimension: nbfc_name {
type: string
sql: ${TABLE}.nbfc_name ;;
}

dimension: partner_name {
type: string
sql: ${TABLE}.partner_name ;;
}

dimension_group: updated_at {
type: time
timeframes: [raw, time, date, week, month, quarter, year]
datatype: datetime
sql: ${TABLE}.updated_at ;;
}

set: detail {
fields: [
disbursed_loans,
nbfc_name,
partner_name,
updated_at_date
]
}
} 

 

 

1 2 175
2 REPLIES 2

Roderick
Community Manager
Community Manager

Thanks for your question! Sharing with our internal teams to see if anyone can help triage this error you're experiencing. 

Is it possible to get this solved?

Top Labels in this Space
Top Solution Authors