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
]
}
}
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?