quality_monitor_refreshes

Operations on a quality_monitor_refreshes resource.

Overview

Name	quality_monitor_refreshes
Type	Resource
Id	databricks_workspace.unitycatalog.quality_monitor_refreshes

Fields

Name	Datatype
end_time_ms	integer
message	string
refresh_id	integer
start_time_ms	integer
state	string
trigger	string

Methods

Name	Accessible by	Required Params	Description
getrefresh	SELECT	refresh_id, table_name, deployment_name	Gets info about a specific monitor refresh using the given refresh ID.
listrefreshes	SELECT	table_name, deployment_name	Gets an array containing the history of the most recent refreshes (up to 25) for this table.
runrefresh	EXEC	table_name, deployment_name	Queues a metric refresh on the monitor for the specified table. The refresh will execute in the background.

SELECT examples

quality_monitor_refreshes (listrefreshes)

SELECT
end_time_ms,
message,
refresh_id,
start_time_ms,
state,
trigger
FROM databricks_workspace.unitycatalog.quality_monitor_refreshes
WHERE table_name = '{{ table_name }}' AND
deployment_name = '{{ deployment_name }}';

quality_monitor_refreshes (getrefresh)

SELECT
end_time_ms,
message,
refresh_id,
start_time_ms,
state,
trigger
FROM databricks_workspace.unitycatalog.quality_monitor_refreshes
WHERE refresh_id = '{{ refresh_id }}' AND
table_name = '{{ table_name }}' AND
deployment_name = '{{ deployment_name }}';