Skip to main content

provider_provider_analytics_dashboards

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

Overview​

Nameprovider_provider_analytics_dashboards
TypeResource
Iddatabricks_workspace.marketplace.provider_provider_analytics_dashboards

Fields​

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstring
dashboard_idstringdashboard_id will be used to open Lakeview dashboard.
versioninteger

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectdeployment_name, workspace_domainGet provider analytics dashboard.
createinsertdeployment_name, workspace_domainCreate provider analytics dashboard. Returns Marketplace specific id. Not to be confused with the
updatereplaceid, deployment_name, workspace_domainUpdate provider analytics dashboard.
get_latest_versionexecdeployment_name, workspace_domainGet latest version of provider analytics 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
deployment_namestringThe Databricks workspace deployment name: the host prefix of the workspace URL (dbc-abcd0123-a1bc on AWS, adb-1234567890123456.7 on Azure, 1234567890123456.7 on GCP). Set DATABRICKS_DEPLOYMENT_NAME to default it for the session. (default: dbc-abcd0123-a1bc, x-stackQL-envVar: DATABRICKS_DEPLOYMENT_NAME)
idstringid is immutable property and can't be updated.
workspace_domainstringThe Databricks workspace domain suffix for the cloud. Selected by DATABRICKS_CLOUD (aws, azure or gcp; default aws). (default: cloud.databricks.com, x-stackQL-envVarSelector: {"envVar":"DATABRICKS_CLOUD","default":"aws","values":{"aws":"cloud.databricks.com","azure":"azuredatabricks.net","gcp":"gcp.databricks.com"}})

SELECT examples​

Get provider analytics dashboard.

SELECT
id,
dashboard_id,
version
FROM databricks_workspace.marketplace.provider_provider_analytics_dashboards
WHERE deployment_name = '{{ deployment_name }}' -- required
AND workspace_domain = '{{ workspace_domain }}' -- required
;

INSERT examples​

Create provider analytics dashboard. Returns Marketplace specific id. Not to be confused with the

INSERT INTO databricks_workspace.marketplace.provider_provider_analytics_dashboards (
deployment_name,
workspace_domain
)
SELECT
'{{ deployment_name }}',
'{{ workspace_domain }}'
RETURNING
id
;

REPLACE examples​

Update provider analytics dashboard.

REPLACE databricks_workspace.marketplace.provider_provider_analytics_dashboards
SET
version = {{ version }}
WHERE
id = '{{ id }}' --required
AND deployment_name = '{{ deployment_name }}' --required
AND workspace_domain = '{{ workspace_domain }}' --required
RETURNING
id,
dashboard_id,
version;

Lifecycle Methods​

Get latest version of provider analytics dashboard.

EXEC databricks_workspace.marketplace.provider_provider_analytics_dashboards.get_latest_version
@deployment_name='{{ deployment_name }}' --required,
@workspace_domain='{{ workspace_domain }}' --required
;