I want to map the variable "version" to the a field as shown in the picture below,Field to map to the data "Nothing AWS Athena(Test)->Data Device Quality",but since the data structure is sophisticated,the column "version" can't display,so I can't select it.Can I map the variable "version" to a SQL Query?Or ,is there any other way to solve this problem
Hi @twinkle
Post "Diagnostic Info" from Admin > Troubleshooting, and Athena driver version.
And have a look here: https://www.metabase.com/docs/latest/troubleshooting-guide/filters.html#are-you-seeing-a-different-kind-of-input-widget-than-you-expected
I don't know what you mean by "sophisticated".
@twinkle You need to create a View on Athena: https://github.com/dacort/metabase-athena-driver/issues/77
Can you give me more information about "Use SQL to extract the fields and then create filters on that SQL question"?Because it seems that the dropdown list value can only be mapped to the raw data, how to be mapped to the SQL question
@twinkle I don't understand your question, but dropdowns can currently only be connected to columns.
There's requests open for custom SQL used for dropdowns.
Upvote by clicking 
on the first post of each issue:
https://github.com/metabase/metabase/issues/5245
https://github.com/metabase/metabase/issues/6820
I can't map the varibale to the Saved SQL question,how to make the “Populate filter options from a saved question(optional)” to show up as follows:
My variable settings panel as fellow:
@twinkle I think you are misunderstanding. It is not possible to do in Metabase currently. Read the issues I have linked, they are feature requests. In other words, you cannot do what you want currently.
I got it.Thank you
@flamber In this case, is there any other way to solve this problem,except creating a View on Athena.
For example, using sql " [[and a.iot_device.firmware_version in ({{Version}})]]", Can customers input multiple version separated by English commas to realize the function of filter mutiple versions?
@twinkle You will have to use Text variable and then split the string like described in several of the comments in https://github.com/metabase/metabase/issues/4728
I don't know Athena, so you'll have to figure out which functions to use there.
Thank you , this problem has been solved.But there is another problem when I connect the SQL question to a dashboard filter.First,the default value which I inputed can't show up after loss of cursor.Second, the value which I inputed in the top bar filter -> "version" also can't show up afer loss of cursor.It works well as a SQL question.The pictures of the two problems attached:
Thank you!I think most people don't know how to use it.It should be improved.HHH