Skip to main content

dashboards

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

Overview

Namedashboards
TypeResource
Idazure.portal.dashboards

Fields

The following fields are returned by SELECT queries:

Azure operation completed successfully.

NameDatatypeDescription
locationstringThe geo-location where the resource lives
propertiesobjectThe resource-specific properties for this resource.
tagsobjectResource tags.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, dashboardNameGets the Dashboard.
list_by_resource_groupselectsubscriptionId, resourceGroupNameGets all the Dashboards within a resource group.
list_by_subscriptionselectsubscriptionIdGets all the dashboards within a subscription.
create_or_updateinsertsubscriptionId, resourceGroupName, dashboardNameCreates or updates a Dashboard.
updateupdatesubscriptionId, resourceGroupName, dashboardNameUpdates an existing Dashboard.
deletedeletesubscriptionId, resourceGroupName, dashboardNameDeletes the Dashboard.

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
dashboardNamestringThe name of the dashboard.
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
subscriptionIdstring (uuid)The ID of the target subscription. The value must be an UUID.

SELECT examples

Gets the Dashboard.

SELECT
location,
properties,
tags
FROM azure.portal.dashboards
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND dashboardName = '{{ dashboardName }}' -- required
;

INSERT examples

Creates or updates a Dashboard.

INSERT INTO azure.portal.dashboards (
data__properties,
data__tags,
data__location,
subscriptionId,
resourceGroupName,
dashboardName
)
SELECT
'{{ properties }}',
'{{ tags }}',
'{{ location }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ dashboardName }}'
RETURNING
location,
properties,
tags
;

UPDATE examples

Updates an existing Dashboard.

UPDATE azure.portal.dashboards
SET
data__properties = '{{ properties }}',
data__tags = '{{ tags }}'
WHERE
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND dashboardName = '{{ dashboardName }}' --required
RETURNING
location,
properties,
tags;

DELETE examples

Deletes the Dashboard.

DELETE FROM azure.portal.dashboards
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND dashboardName = '{{ dashboardName }}' --required
;