Use filtered value to create derived table dynamically

[vaidehi]

I have a column ID which has tens of thousands of values. I have added this ID field filter in the dashboard(unfortunately the drop down does not show any values) and when the user enters the value, I need that value to be passed within the derived table SQL to generate the resultset. This SQL uses multiple large tables and hence I want this ID to get filtered within each table in the SQL to limit the data being read and thus reduce the cost.

So I tried

1. adding ID filter within the Look itself and making the field filter in the dashboard compulsory - DIDN'T WORK

2. Used ID param in LookML and used parameter_value in the SQL which WORKED but dropdown was not showing values inspite of using suggest_dimension
3. Used ID filter - SAME CASE AS above - dropdown not showing values

[sam8]

I think a parameter best suits your use case. If we proceed with option 2, and you want to populate the dropdown, have you considered using either allowed_value or suggestions to hard code a list?