Schema:: LOCAL

DATA_QUALITY_MONITORING_RESULTS view¶

This view displays a row for each result of calling a data metric function in your account.

Columns¶

The columns in the view are defined as follows:

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 Schedule your DMFs to run.
`measurement_time`	TIMESTAMP_LTZ	The time at which the metric is evaluated.
`table_id`	NUMBER	Internal/system-generated identifier of the table where the rule is associated. Rules could either be associated directly to the table or to any column of the table.
`table_name`	VARCHAR	Name of the table.
`table_schema`	VARCHAR	Name of the schema name that contains the table.
`table_database`	VARCHAR	Name of the database that contains the table.
`metric_id`	NUMBER	Internal/system-generated identifier of the metric.
`metric_name`	VARCHAR	Name of the metric.
`metric_schema`	VARCHAR	Name of the schema that contains of the metric.
`metric_database`	VARCHAR	Name of the database that contains the metric.
`metric_return_type`	VARCHAR	Return type of the metric.
`arguments_ids`	ARRAY	An array that contains IDs of reference arguments used to evaluate the rule. Entries of the array are ordered by the positions of arguments.
`arguments_types`	ARRAY	An array that contains types of reference arguments used to evaluate the rule. Entries of the array are ordered by the positions of arguments. Currently only supports COLUMN type arguments.
`arguments_names`	ARRAY	An array that contains names of reference arguments used to evaluate the rule. Entries of the array are ordered by the positions of arguments.
`reference_id`	VARCHAR	The ID to uniquely identify the metric entity reference, known as the association ID.
`value`	VARIANT	The result of the evaluation.

Access control requirements¶

The role used to query the view must be granted the SNOWFLAKE.DATA_QUALITY_MONITORING_VIEWER application role or the SNOWFLAKE.DATA_QUALITY_MONITORING_ADMIN application role.