Db query error: pq: relation "<table>" does not exist

Grafana PostgreSQL
1

  • What Grafana version and what operating system are you using?
    Grafana v11.2.1 (6291d0d714)

  • What are you trying to achieve?
    Using postgres as a data source run multiple queries to eventually join into a single table

  • How are you trying to achieve it?
    Using a table visualization.
    I add two queries A and B
    Both A and B are valid on their own (verified using explore)
    When both A and B are enabled within the visualization config I get the error db query error: pq: relation "<table>" does not exist
    If I add query C then A and B will now return the above error

  • What happened?
    Valid query results in the error db query error: pq: relation "<table>" does not exist

  • What did you expect to happen?
    My valid queries would execute successfully and I could use a join transformation to combine output from the multiple queries.

  • Can you copy/paste the configuration(s) that you are having problems with?
    No, but any two valid postgres queries should reproduce this issue

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    The UI displays db query error: pq: relation "<table>" does not exist for each query that’s not the last one executed

  • Did you follow any online instructions? If so, what is the URL?
    No