Creating template variable using Infinity Query
Like panels, you can have your own CSV/JSON in your variable. Variable queries are expected to return one or more columns. This will give you the ability to get your variables set from CSV/JSON/XML or any other external sources.

Note: If you want to have variables with different text than its value, then rename the columns to
__textand__valuerespectively.
Note: It is always recommended to rename your columns to
__text/__valuewhen having more than 1 column in your variable query. Any other columns except__text/__valuewill be ignored when there are more than 1 column. This is useful in scenarios where backend queries require more columns to perform operations such as filtering but want to select only one column for variable.



