Use PostgreSQL Schemas in Query Builder

Grafana Dashboards
1

I’m using Grafana 11.2.0 and PostgreSQL 16 on a Debian VPS.

I’m trying to use the Query Builder for one panel in my Dashboard, but when i try to select a Table i get “no options found”.
The grafana user has all the necessary permission to see and select the tables (in fact, if i try to query using code, it works without problems), so I think the problem is that my tables are not in the “public” schema.

Is there any workaround or commands to use to resolve this issue?

2

I guess your Grafana DB user needs read access for information_schema, so it can get details about your DB schema.

3

Is there an information_schema in Postgres? By the way, I don’t think that’s the issue, because in pgAdmin the grafana user can see all tables with no problems. I’ve “resolved” by using writing the SQL queries by hand in the code panel.

1 Like
4

This is not a problem to see table. That’s a problem to describe table