I am trying to parameterise my connection:
view: view_name {
sql_table_name: {% parameter tablename %};;
parameter: tablename{
type: unquoted
allowed_value: {
label: "Staging"
value: "`datatbase.staging.table`"
}
allowed_value: {
label: "Production"
value: "`database.prod.table`"
}
default_value: "`database.prod.table`"
}
I get this error:
Filter on unquoted field view_name.tablename must contain only underscores, numbers, letters, '.', or '$'.
I’m not sure how to re-wrote the value to make this work.
Thanks!
Solved! Go to Solution.