Schema:: LOCAL

DATA_QUALITY_MONITORING_EXPECTATION_STATUS view¶

This view displays a row for every time a data metric function (DMF) with an expectation was run in your account.

Columns¶


Column name	Data type	Description
`scheduled_time`	TIMESTAMP_LTZ	The time the DMF is scheduled to run based on the schedule that you set for the table or view.
`change_commit_time`	TIMESTAMP_LTZ	The time the DMF trigger operation occurred, or `None` if the DMF is not scheduled to run by a trigger operation. For information about the trigger operation, see Adjust the schedule for DMFs.
`measurement_time`	TIMESTAMP_LTZ	The time at which the metric was evaluated.
`table_id`	NUMBER	Internal/system-generated identifier of the table that is associated with the DMF.
`table_name`	VARCHAR	Name of the table that is associated with the DMF.
`table_schema`	VARCHAR	Name of the schema name that contains the table that is associated with the DMF.
`table_database`	VARCHAR	Name of the database that contains the table that is associated with the DMF.
`metric_id`	NUMBER	Internal/system-generated identifier of the DMF.
`metric_name`	VARCHAR	Name of the DMF.
`metric_schema`	VARCHAR	Name of the schema that contains the DMF.
`metric_database`	VARCHAR	Name of the database that contains the DMF.
`metric_return_type`	VARCHAR	Return type of the DMF.
`arguments_ids`	ARRAY	Array of the identifiers of the DMF arguments. Array elements are in the same order as the arguments.
`arguments_types`	ARRAY	Array of the domain/type of each argument. Array elements are in the same order as the arguments. Currently only supports COLUMN type arguments.
`arguments_names`	ARRAY	Array of the names of the DMF arguments. For column arguments, each element is the name of a column. Array elements are in the same order as the arguments.
`reference_id`	VARCHAR	The ID to uniquely identify the metric entity reference, known as the association ID.
`value`	VARIANT	The result of the DMF evaluation.
`expectation_name`	VARCHAR	Name that was given to the expectation when it was added to the association between the DMF and the object.
`expectation_id`	VARCHAR	System-generated identifier.
`expectation_expression`	VARCHAR	Boolean expression of the expectation. See Defining what meets the expectation.
`expectation_violated`	BOOLEAN	If TRUE, the expectation was violated. An expectation is violated when the `expectation_expression` evaluates to FALSE. A NULL value indicates the evaluation of the expectation failed.
`group_by_info`	ARRAY	For an expectation defined on an association created with a WITHIN GROUP clause, an array of objects that identifies the group this row corresponds to. Each object describes one grouping column and its value, with the keys `id`, `name`, and `value`. The array is empty for non-grouped associations. For more information, see Apply data quality checks by group.

Access control requirements¶

The role used to query the view must be granted one of the following application roles:

SNOWFLAKE.DATA_QUALITY_MONITORING_VIEWER
SNOWFLAKE.DATA_QUALITY_MONITORING_ADMIN