Schema:: ACCOUNT_USAGE

DATA_METRIC_FUNCTION_REFERENCES view¶

This Account Usage view can be used to identify data metric function objects and their references in your account.

The view is complementary to the Information Schema table function DATA_METRIC_FUNCTION_REFERENCES.

Columns¶

The view returns the following columns:

Column	Data type	Description
`metric_database_name`	VARCHAR	The database that stores the data metric function.
`metric_schema_name`	VARCHAR	The schema that stores the data metric function.
`metric_name`	VARCHAR	The name of the data metric function.
`argument_signature`	VARCHAR	The type signature of the metrics arguments.
`data_type`	VARCHAR	The return data type of the data metric function.
`ref_database_name`	VARCHAR	The database name that contains the object on which the data metric function is added.
`ref_schema_name`	VARCHAR	The schema name that contains the object on which the data metric function is added.
`ref_entity_name`	VARCHAR	The name of the table or view on which the data metric function is set.
`ref_entity_domain`	VARCHAR	The object type (table, view) on which the data metric function is set.
`ref_arguments`	ARRAY	Identifies the reference arguments used to evaluate the rule.
`ref_id`	VARCHAR	A unique identifier for the association of the data metric function to the table or view.
`schedule`	VARCHAR	The schedule to run the data metric function on the table or view. The value for the schedule is always the most recent and effective schedule.
`schedule_status`	VARCHAR	The status of the metrics association. One of the following: `STARTED` The data metric association on the table or view is scheduled to run. `SUSPENDED` The data metric association on the table or view is not scheduled to run. This value also occurs when the role in use that calls the function does not have the OWNERSHIP privilege on the table. When querying the Account Usage view, the following values are visible by default; however, when calling the table function you must use a role with the OWNERSHIP privilege on the table to see these values: `SUSPENDED_TABLE_DOES_NOT_EXIST_OR_NOT_AUTHORIZED` One of the following: The table is dropped. The schema or database that contains the table is dropped The schema or database that contains the table cannot be resolved by the table owner role. “Resolved” means the role that calls the function does not have the appropriate privileges on the schema or database that contains the table. `SUSPENDED_DATA_METRIC_FUNCTION_DOES_NOT_EXIST_OR_NOT_AUTHORIZED` One of the following: The DMF is dropped. The schema or database that contains the DMF is dropped. The schema or database that contains the DMF cannot be resolved by the table owner role. `SUSPENDED_TABLE_COLUMN_DOES_NOT_EXIST_OR_NOT_AUTHORIZED` One of the following: The target table column is dropped. The schema or database that contains the column is dropped. The schema or database that contains the column cannot be resolved by the table owner role. `SUSPENDED_INSUFFICIENT_PRIVILEGE_TO_EXECUTE_DATA_METRIC_FUNCTION` The table owner role does not have the EXECUTE DATA METRIC FUNCTION privilege. `SUSPENDED_ACTIVE_EVENT_TABLE_DOES_NOT_EXIST_OR_NOT_AUTHORIZED` The event table is not set at the account level.

Usage notes¶

Latency for the view might be up to 3 hours.
To query this view, use a role that is granted either of these database roles at a minimum: SNOWFLAKE.GOVERNANCE_VIEWER or SNOWFLAKE.USAGE_VIEWER.