Dynamic derived table based on filter

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 😞 

0 2 636
2 REPLIES 2
Top Labels in this Space
Top Solution Authors