dashboard_schedules

Operations on a dashboard_schedules resource.

Overview

Name	dashboard_schedules
Type	Resource
Id	databricks_workspace.lakeview.dashboard_schedules

Fields

Name	Datatype
create_time	string
cron_schedule	object
dashboard_id	string
display_name	string
etag	string
pause_status	string
schedule_id	string
update_time	string
warehouse_id	string

Methods

Name	Accessible by	Required Params	Description
getschedule	SELECT	dashboard_id, schedule_id, deployment_name
listschedules	SELECT	dashboard_id, deployment_name
createschedule	INSERT	deployment_name
deleteschedule	DELETE	dashboard_id, schedule_id, deployment_name
updateschedule	UPDATE	deployment_name

SELECT examples

dashboard_schedules (listschedules)

SELECT
create_time,
cron_schedule,
dashboard_id,
display_name,
etag,
pause_status,
schedule_id,
update_time,
warehouse_id
FROM databricks_workspace.lakeview.dashboard_schedules
WHERE dashboard_id = '{{ dashboard_id }}' AND
deployment_name = '{{ deployment_name }}';

dashboard_schedules (getschedule)

SELECT
create_time,
cron_schedule,
dashboard_id,
display_name,
etag,
pause_status,
schedule_id,
update_time,
warehouse_id
FROM databricks_workspace.lakeview.dashboard_schedules
WHERE dashboard_id = '{{ dashboard_id }}' AND
schedule_id = '{{ schedule_id }}' AND
deployment_name = '{{ deployment_name }}';

INSERT example

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

dashboard_schedules

/*+ create */
INSERT INTO databricks_workspace.lakeview.dashboard_schedules (
deployment_name,
data__cron_schedule,
data__pause_status,
data__display_name,
data__etag,
data__warehouse_id
)
SELECT 
'{{ deployment_name }}',
'{{ cron_schedule }}',
'{{ pause_status }}',
'{{ display_name }}',
'{{ etag }}',
'{{ warehouse_id }}'
;

Manifest

- name: your_resource_model_name
  props:
  - name: cron_schedule
    value:
      quartz_cron_expression: 0 0 8 * * ?
      timezone_id: Europe/London
  - name: pause_status
    value: UNPAUSED
  - name: display_name
    value: Monthly Traffic Report Snapshot
  - name: etag
    value: '80611980'
  - name: warehouse_id
    value: 47bb1c472649e711

UPDATE example

Updates a dashboard_schedules resource.

/*+ update */
-- replace field1, field2, etc. with the fields you want to update        
UPDATE databricks_workspace.lakeview.dashboard_schedules
SET field1 = '{{ value1 }}',
field2 = '{{ value2 }}', ...
WHERE deployment_name = '{{ deployment_name }}';

DELETE example

Deletes a dashboard_schedules resource.

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