Variable key value regex, using Grafana interpolates in dashboard

[yosiasz]

I think this is the issue, out __value first

__value and __text for variables not working as expected

What Grafana version and what operating system are you using? 9.3.6 running on MacOS, datasource is using the BigQuery datasource from Grafana Labs version 1.2.4. What are you trying to achieve? Setup a variable with a value and a text field so that the text field is displayed but in the dashboard I can reference the value field in other sql. How are you trying to achieve it? I am using the following SQL for the variable: SELECT DISTINCT ctx.Site AS __text, ctx.SiteID AS __value F…