I need to query for the same chart in different databases
It is possible ?
I’m using SQL SERVER
yes you can. there are a few ways to do it. depends on what you are trying to show in the visualization
this is the way I would do it.
create a fake database called grafana
in there create 2 views one pointing to db1 the other pointing to db2
then you have only 1 db connection in grafana called grafana.
but you make the call to 2 separate views.