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 😞