Schema:: ACCOUNT_USAGE

DATA_METRIC_FUNCTION_EXPECTATIONS view¶

This Account Usage view lists the expectations in an account. It lists the expectations that were added to an association between a data metric function (DMF) and an object.

Columns¶

Column name	Data type	Description
METRIC_DATABASE_NAME	VARCHAR	Database that contains the data metric function.
METRIC_SCHEMA_NAME	VARCHAR	Schema that contains the data metric function.
METRIC_NAME	VARCHAR	Name of the data metric function.
ARGUMENT_SIGNATURE	VARCHAR	Type signature of the metric arguments.
DATA_TYPE	VARCHAR	Return data type of the data metric function.
REF_DATABASE_NAME	VARCHAR	Database that contains the object that is associated with the data metric function.
REF_SCHEMA_NAME	VARCHAR	Schema that contains the object that is associated with the data metric function.
REF_ENTITY_NAME	VARCHAR	Name of the table or view that is associated with the data metric function.
REF_ENTITY_DOMAIN	VARCHAR	Type of the object (table, view) that the data metric function is associated with.
REF_ARGUMENTS	ARRAY	Reference arguments used to evaluate the rule.
REF_ID	VARCHAR	System-generated identifier for the association of the data metric function to the table or view.
EXPECTATION_ID	VARCHAR	System-generated identifier.
EXPECTATION_NAME	VARCHAR	Name that was given to the expectation when it was added to the association between the DMF and the object.
EXPECTATION_EXPRESSION	VARCHAR	Boolean expression of the expectation. See Defining what meets the expectation.

Usage notes¶

Latency for the view might be up to 30 minutes.