We are connecting to an Azure SQL Server which has few Databases on it. We are able to setup and use the Microsoft SQL Server Data Source(https://grafana.com/docs/grafana/latest/features/datasources/mssql/).
While configuring the Data Source we have set the connection to a particular Database.As Azure SQL Server does not support USE statements.Currently we need to setup DataSource connection to individual databases on Azure SQL.
Since we have multiple databases on that Azure SQL Server, we need to template the database name so that we can resuse the same Data Source Connection and connect to multiple databases on it.
We need to find a way of doing it by passing the DataSource Properties while querying the MS SQL Data Source in the Dashboard.
Please suggest. Any help will be appreciated.