I have configured a PostgreSQL data source. However, I am unable to query data from it. There is no table available to select, why? Please note that I have tables in separate schemas, eg: Schema 1 → Table 1, Table 2, etc. Schema 2 → Table 3, Table 4, etc. [image]

Turns out, grafana overrides the table name with the value column header for time-series data. So I do not need to change anything.

Tell us what the error message is. Antony.

[image] pooh: Tell us what the error message is. [image] [image] yosiasz: do you use any querying tool against your postgres db? like pgql? I can query it using dbeaver, an SQL IDE.

[image] usrcosmicglow: I can query it using dbeaver, an SQL IDE run the same query that fails in grafana, using dbeaver

[image] yosiasz: run the same query that fails in grafana, using dbeaver SELECT * FROM macros.“DFF”; This one worked. This also solved the issue of how to specify schemas. But there is a new problem now. There is no way to identify data for individual tables/curves, it just says “value” f…

What does the result look like in dbbeaver? Please share screen grab if dbbeaver results

Hi @usrcosmicglow , [image] usrcosmicglow: SELECT * FROM macros.“DFF”; It worked because as you probably have searched and discovered that you’ll need to use the format “my_schema”.“my_table” to query a specific schema on Postgresql. [image] usrcosmicglow: But there is a new problem now.…

[image] yosiasz: What does the result look like in dbbeaver? I was asking for you to show us what the original query SELECT * FROM macros."DFF" looks like in dbbeaver

Similar to the one above, except “value” as the header in the 2nd column. I’m away from the computer so unable to attach the screenshot here. The issue is in Grafana, there is not query name associated with the data. So, each data query result is having a name “value”.

Try to use table format, not timeseries.

How to query from PostgreSQL data source?

Grafana Cloud

usrcosmicglow March 29, 2024, 3:48pm 13

I have since changed my code and selected custom columns, but the previous problem is still there. The Grafana Query name is missing in the output. How do I ensure that the query name is Present?

Updated code:

In Grafana, the table name is shown as the last column header, so the Query name is missing as I explained above.

Topic		Replies	Views
PostgreSQL table suggestion not available in builder view PostgreSQL explore	11	1829	April 2, 2024
Grafana column no value suggestion in query builder PostgreSQL templating , postgres	0	404	December 20, 2021
Use PostgreSQL Schemas in Query Builder Dashboards query-help	3	516	September 24, 2024
Connected to Postgres DB but dashboard has no data PostgreSQL datasource , dashboard	13	3355	May 25, 2023
Result query grafana not same with source data (postgresql) Dashboards query-help , timestamp	2	220	May 20, 2024

How to query from PostgreSQL data source?

Related topics