Better to support numeric values of variable query result.

[tiantangkuohai]

Is your feature request related to a problem? Please describe.
I use athena datasource in variable. The query looks like select id from some_table limit 1000, and the id field is number type. Query executes succeed, but Preview of values is empty.

Describe the solution you'd like
I have to cast id from number to varchar.

Describe alternatives you've considered
It better to support numeric data type in variable query.

Additional context

[idastambuk]

Hi @tiantangkuohai, thanks for the submission. I can confirm I see the same problem with Preview, even though I can confirm in the Network tab there are values in the response.
However, when I save the variable and go back to the dashboard, I can see the values in the dropdown for the variable, so it seems like just the Preview isn't working. Can you confirm you're seeing the same thing?

[idastambuk]

I don't see the same behaviour in 12.1 anymore, so closing this due to inactivity