Hi Looker expert, I wonder if there is way to access the filter value inside the derived table sql statement? What I would like to achieve is that ask users to input a table name, and do a select query on the table.I would imagine it looks sth like:
view: test_table { derived_table: { sql: SELECT * FROM {{ % parameter table_filter % }} } filter: table_filter { type: string }}
Went through few docs but could not make it work 😞
When referencing a parameter, don’t use double {{. Just {% parameter param_name %}
view: test_table {
derived_table: {
sql: SELECT * FROM {% parameter table_filter %}
}
filter: table_filter {
type: string
}
}
This doesn't work for me... i'm working with bigquery and i tried with parameters and filters and the sql doesn't put the value...