Hi Dear Community !
We are working with Grafana to display performance data that is stored on a single Postgres Database.
The use case we have is that users will be processing performance data from different clusters using an internal tool we have created. That data will land in the same DB but we have a key on the tables that identify uniquely each cluster and in Grafana the user can select the cluster he wants to work on.
We believe that this solution is not ideal and we would like to create an independent DB for every cluster. The DB will be created on the fly by our internal tool.
The problem we are facing is on tha Grafana side and is: How can we make the datasource “selectable” from the dashboards we have OR how can generate a link on teh fly that would switch to the newly created datasource.
Our big problem is that we don’t know how can we work with multiple datasources on Grafana efficiently in order to respond to our particular use case.
We have done some research and we found out that there are API’s available to create/modify datasources but if we are going to have multiple users using the same Grafana frontent how can each user look at his own datasource without affecting the others.
Thank you so much !