POLICY_REFERENCES View¶

This Account Usage view can be used to identify the objects and columns on which a Column-level Security masking policy is set.

The view is complementary to the information schema table function POLICY_REFERENCES.

Columns¶

Column Name	Data Type	Description
POLICY_DB	TEXT	The database in which the masking policy is set.
POLICY_SCHEMA	TEXT	The schema in which the policy is set.
POLICY_ID	NUMBER	Internal/system-generated identifier for the masking policy.
POLICY_NAME	TEXT	The name of the policy.
POLICY_KIND	TEXT	The type of policy.
REF_DATABASE_NAME	TEXT	The name of the database containing an object that the queried object references.
REF_SCHEMA_NAME	TEXT	The name of the schema containing an object that the queried object references.
REF_ENTITY_NAME	NUMBER	The name of the object (i.e. table_name, view_name) on which the policy is set.
REF_ENTITY_DOMAIN	TEXT	The object type (i.e. table, view) on which the policy is set.
REF_COLUMN_NAME	TEXT	The column name on which the policy is set.
REF_ARG_COLUMN_NAMES	TEXT	Returns NULL for rows in the query result in which a Column-level Security masking policy is set.

Latency for the view may be up to 120 minutes (2 hours).
The view only displays objects for which the current role for the session has been granted access privileges.