Schema:

ACCOUNT_USAGE

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 the object was last altered. See Usage Notes.

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 ROLE or DATABASE_ROLE. . If a Snowflake Native App owns the object, the value is APPLICATION. . Snowflake returns NULL if you delete the object because a deleted object does not have an owner role.

OPTIONS

VARIANT

The value for the EXEMPT_OTHER_POLICIES property in the policy. If set to TRUE, the column returns { "EXEMPT_OTHER_POLICIES: "TRUE" }. If the property is set to FALSE or not set at all, the column returns NULL.

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.

  • The LAST_ALTERED column is updated when the following operations are performed on an object:

    • DDL operations.

    • DML operations (for tables only).

    • Background maintenance operations on metadata performed by Snowflake.