PostgreSQL data source Variable Querry

  • What Grafana version and what operating system are you using?
    l’m using Grafana 9.3.2

  • What are you trying to achieve?
    l’m trying to creat a Query variable
    i have 1 Haus and 10 Rooms

  • How are you trying to achieve it?

  • What happened?
    returning nothing

  • What did you expect to happen?
    l’m expecting to return 10 Rooms where i can be able to select the Room

  • Can you copy/paste the configuration(s) that you are having problems with?

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    This variable is not references by any Variable or Dashboard

  • Did you follow any online instructions? If so, what is the URL?
    yes i did
    PostgreSQL data source | Grafana documentation

What happens when you tun this query in PgAdmin?

could you please tell me how to do it.

Other than pgAdmin, do you have a tool to run pg queries against your database?