dashboard_subscriptions

Operations on a dashboard_subscriptions resource.

Overview

Name	dashboard_subscriptions
Type	Resource
Id	databricks_workspace.lakeview.dashboard_subscriptions

Fields

Name	Datatype
create_time	string
created_by_user_id	string
dashboard_id	string
etag	string
schedule_id	string
subscriber	object
subscription_id	string
update_time	string

Methods

Name	Accessible by	Required Params	Description
getsubscription	SELECT	dashboard_id, schedule_id, subscription_id, deployment_name
listsubscriptions	SELECT	dashboard_id, schedule_id, deployment_name
createsubscription	INSERT	deployment_name
deletesubscription	DELETE	dashboard_id, schedule_id, subscription_id, deployment_name

SELECT examples

dashboard_subscriptions (listsubscriptions)

SELECT
create_time,
created_by_user_id,
dashboard_id,
etag,
schedule_id,
subscriber,
subscription_id,
update_time
FROM databricks_workspace.lakeview.dashboard_subscriptions
WHERE dashboard_id = '{{ dashboard_id }}' AND
schedule_id = '{{ schedule_id }}' AND
deployment_name = '{{ deployment_name }}';

dashboard_subscriptions (getsubscription)

SELECT
create_time,
created_by_user_id,
dashboard_id,
etag,
schedule_id,
subscriber,
subscription_id,
update_time
FROM databricks_workspace.lakeview.dashboard_subscriptions
WHERE dashboard_id = '{{ dashboard_id }}' AND
schedule_id = '{{ schedule_id }}' AND
subscription_id = '{{ subscription_id }}' AND
deployment_name = '{{ deployment_name }}';

INSERT example

Use the following StackQL query and manifest file to create a new dashboard_subscriptions resource.

dashboard_subscriptions

/*+ create */
INSERT INTO databricks_workspace.lakeview.dashboard_subscriptions (
deployment_name,
data__subscriber,
data__etag
)
SELECT 
'{{ deployment_name }}',
'{{ subscriber }}',
'{{ etag }}'
;

Manifest

- name: your_resource_model_name
  props:
  - name: subscriber
    value:
      user_subscriber:
        user_id: '3294322584244938'
  - name: etag
    value: '80611980'

DELETE example

Deletes a dashboard_subscriptions resource.

/*+ delete */
DELETE FROM databricks_workspace.lakeview.dashboard_subscriptions
WHERE dashboard_id = '{{ dashboard_id }}' AND
schedule_id = '{{ schedule_id }}' AND
subscription_id = '{{ subscription_id }}' AND
deployment_name = '{{ deployment_name }}';