I have successfully connected my PostgreSQL and grafana-server and was getting a table with some data in it when I viewed it through the table option in visualization but now I’m trying to do the same with another DB it shows successful database connection but when I try to see the data it says no data to show. I am new to grafana and psql so any help would be appreciated.
And neither the grafana nor the postgresql logs show any helpful information.
Most likely your query is not returning any data. You can use the Query Inspector from the Edit page to see what the query is and what data it returns.