InfluxV3 - SQL : Query OK in InfluxDB explore but not in Grafana variable

Grafana InfluxDB
1

  • What Grafana version and what operating system are you using?
    I am using Grafana v11.4.0 and InfluxDBV3 with SQL

  • What are you trying to achieve?
    I am trying to display a dropdown menu displaying distincs strings store as fields in my influxDBV3 database.

  • How are you trying to achieve it?

  • I define a variable with the following query: SELECT DISTINCT(test_description) FROM “test_bench_metrics_2” WHERE model=‘A100LS’

  • What happened?
    in influxDB V3 cloud explore menu, the result is ok and I got a list of “test_description”
    in Grafana, I have no value displayed in the dropdown list

  • What did you expect to happen?
    I expect to have my list displayed in the dropdown list.
    I expect to have the same behavior between InfluxDB and Grafana