Skip to main content

managed_dashboards

Creates, updates, deletes, gets or lists a managed_dashboards resource.

Overview

Namemanaged_dashboards
TypeResource
Idazure.dashboard.managed_dashboards

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringFully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
namestringThe name of the resource.
locationstringThe geo-location where the resource lives. Required.
provisioningStatestringProvisioning state of the resource. Known values are: "Accepted", "Creating", "Updating", "Deleting", "Succeeded", "Failed", "Canceled", "Deleted", and "NotSpecified". (Accepted, Creating, Updating, Deleting, Succeeded, Failed, Canceled, Deleted, NotSpecified)
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
tagsobjectResource tags.
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, dashboard_name, subscription_idGet the properties of a specific dashboard for grafana resource.
listselectresource_group_name, subscription_idList all resources of dashboards under the specified resource group.
list_by_subscriptionselectsubscription_idList all resources of dashboards under the specified subscription.
createinsertresource_group_name, dashboard_name, subscription_id, locationCreate or update a dashboard for grafana resource. This API is idempotent, so user can either create a new dashboard or update an existing dashboard.
updateupdateresource_group_name, dashboard_name, subscription_idUpdate a dashboard for Grafana resource.
deletedeleteresource_group_name, dashboard_name, subscription_idDelete a dashboard for Grafana resource.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
dashboard_namestringThe name of the Azure Managed Dashboard. Required.
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
subscription_idstring

SELECT examples

Get the properties of a specific dashboard for grafana resource.

SELECT
id,
name,
location,
provisioningState,
systemData,
tags,
type
FROM azure.dashboard.managed_dashboards
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND dashboard_name = '{{ dashboard_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Create or update a dashboard for grafana resource. This API is idempotent, so user can either create a new dashboard or update an existing dashboard.

INSERT INTO azure.dashboard.managed_dashboards (
tags,
location,
properties,
resource_group_name,
dashboard_name,
subscription_id
)
SELECT
'{{ tags }}',
'{{ location }}' /* required */,
'{{ properties }}',
'{{ resource_group_name }}',
'{{ dashboard_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
location,
properties,
systemData,
tags,
type
;

UPDATE examples

Update a dashboard for Grafana resource.

UPDATE azure.dashboard.managed_dashboards
SET
tags = '{{ tags }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND dashboard_name = '{{ dashboard_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
location,
properties,
systemData,
tags,
type;

DELETE examples

Delete a dashboard for Grafana resource.

DELETE FROM azure.dashboard.managed_dashboards
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND dashboard_name = '{{ dashboard_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;