Parameter in sql table name

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 Solved
0 4 3,957
1 ACCEPTED SOLUTION

Hey Dawid!

That worked, thanks!

View solution in original post

4 REPLIES 4
Top Labels in this Space