How to manage data sources in Azure Managed Grafana

1. Your workspace includes Core Grafana plugins by default. If you want to use another type of data source, first install its plugin by following the instructions in Add a plugin.

2. Add the data source to your workspace.

   1. Open your Azure Managed Grafana workspace in the Azure portal and go to Overview > Endpoint to open the Grafana UI.
   2. In the Grafana UI, open the menu on the left and select Connections > Data sources > Add new data source.
   3. Select a data source from the list, fill out the required fields, and select Save & test to update the data source configuration and test it.

   

Run the az grafana data-source create command to add a Grafana core data source by using Azure CLI.

For example, to add an Azure SQL data source, run:

az grafana data-source create --name <workspace-name> --definition '{
  "access": "proxy",
  "database": "testdb",
  "jsonData": {
    "authenticationType": "SQL Server Authentication",
    "encrypt": "false"
  },
  "secureJsonData": {
    "password": "verySecretPassword"
  },
  "name": "Microsoft SQL Server",
  "type": "mssql",
  "url": "<url>",
  "user": "<user>"
}'

1. Open the menu on the left and select Connections > Data sources.

   

2. Azure Monitor appears as a built-in data source for your Azure Managed Grafana workspace. Select Azure Monitor.

3. In the Settings tab, authenticate through Managed Identity and select your subscription from the dropdown list, or alternatively enter your App Registration details. When you select Managed identity, the authentication and authorization are through the system-assigned or the user-assigned managed identity you configured in your Azure Managed Grafana workspace. By using a managed identity, you can assign permissions for your Azure Managed Grafana workspace to access Azure Monitor data without manually managing service principals in Microsoft Entra ID.

Run the az grafana data-source update command to update the configuration of your Azure Monitor data sources by using Azure CLI.

For example:

az grafana data-source update --data-source 'Azure Monitor' --name <workspace-name> --definition '{ 
  "datasource": {
    "access": "proxy",
    "basicAuth": false,
    "basicAuthUser": "",
    "database": "",
    "id": 1,
    "isDefault": false,
    "jsonData": {
      "azureAuthType": "msi",
      "subscriptionId": "<subscription-ID>"
    },
    "name": "Azure Monitor",
    "orgId": 1,
    "readOnly": false,
    "secureJsonFields": {},
    "type": "grafana-azure-monitor-datasource",
    "typeLogoUrl": "",
    "uid": "azure-monitor-oob",
    "url": "",
    "user": "",
    "version": 1,
    "withCredentials": false
  },
  "id": 1,
  "message": "Datasource updated",
  "name": "Azure Monitor"
}

Remove a data source in the Azure portal:

1. Open your Azure Managed Grafana workspace in the Azure portal.
2. Select Overview from the left menu, and then open the Endpoint URL.
3. In the Grafana portal, go to Connections > Your connections.
4. Select the data source you want to remove and select Delete.

Run the az grafana data-source delete command to remove an Azure Managed Grafana data source by using Azure CLI. In the following sample, replace the placeholders <workspace-name> and <id> with the name of the Azure Managed Grafana workspace and the name, ID, or UID of the data source.

az grafana data-source delete --name <workspace-name> --data-source <id>