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