Dynamic derived table based on filter

[Shengpei1]

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 😞 

[clathrop]

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        
  }
}

[Krit0_74]

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...