Toggle between data sources using a parameter possible?

Looker Q&A Looker
1

I have two tables that are just huge and I don’t want to union them, so I was thinking I could just toggle between the two.

I have the below in lookml, but I’m getting this error in the dashboard. how can I get this to pass to read as a BQ table?

‘Filter on unquoted field benchmark_rez.data_source must contain only underscores, numbers, letters, ‘.’, or ‘$’.’

view: benchmark_rez {
derived_table: {
sql: SELECT * FROM {% parameter data_source %} ;;
}

parameter: data_source {
label: “Booking or Arrival”
type: unquoted

allowed_value: {
  label: "Book Date"
  value: "(PII Removed by Staff).benchmark.benchmark-rez"
}
allowed_value: {
  label : "Arrival Date"
  value: "(PII Removed by Staff).benchmark.benchmark-rez-other"
}

}

2

What is this value? it can’t be in SQL field as it breaks BigQuery conventions of allowed characters for columns, which the error indicates

3

I put a fake value, but it seems like the staff removed it.

it’s just the project name in BQ

4

Then perhaps you need backticks for the name “` `" since the error is clear, the scope of the project.schema.table name is not correct