Field to map to table

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:
I don't know what you mean by "sophisticated".

The raw data is as follows, it can't show up in the matabase

@twinkle You need to create a View on Athena:

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 :+1: on the first post of each issue:

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


@twinkle Press Enter after inputting value.

Thank you!I think most people don't know how to use it.It should be improved.HHH