- Schema:
MASKING_POLICIES View¶
This Account Usage view provides the masking policies in your account.
Each row in this view corresponds to a different masking policy.
Columns¶
Column Name |
Data Type |
Description |
---|---|---|
POLICY_NAME |
TEXT |
Name of the masking policy. |
POLICY_ID |
NUMBER |
Internal/system-generated identifier for the masking policy. |
POLICY_SCHEMA_ID |
TEXT |
Internal/system-generated identifier for the schema in which the policy resides. |
POLICY_SCHEMA |
TEXT |
Schema to which the masking policy belongs. |
POLICY_CATALOG_ID |
TEXT |
Internal/system-generated identifier for the database in which the policy resides. |
POLICY_CATALOG |
TEXT |
Database to which the masking policy belongs. |
POLICY_OWNER |
TEXT |
Name of the role that owns the masking policy. |
POLICY_SIGNATURE |
TEXT |
Type signature of the masking policy’s arguments. |
POLICY_RETURN_TYPE |
TEXT |
Return value data type. |
POLICY_BODY |
TEXT |
Masking policy definition. |
POLICY_COMMENT |
TEXT |
Comments entered for the masking policy (if any). |
CREATED |
TIMESTAMP_LTZ |
Date and time when the masking policy was created. |
LAST_ALTERED |
TIMESTAMP_LTZ |
Date and time when the masking policy was last altered. |
DELETED |
TIMESTAMP_LTZ |
Date and time when the masking policy was dropped. |
OWNER_ROLE_TYPE |
TEXT |
The type of role that owns the object, either |
Usage Notes¶
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.