Schema:: ACCOUNT_USAGE

JOIN_POLICIES view¶

This Account Usage view lists the join policies in your account.

Each row in this view corresponds to a different join policy.

Columns¶

Column Name	Data Type	Description
POLICY_ID	NUMBER	Internal/system-generated identifier for the policy.
POLICY_NAME	TEXT	Name of the policy.
POLICY_SCHEMA_ID	TEXT	Internal/system-generated identifier for the schema in which the policy resides.
POLICY_SCHEMA	TEXT	Schema that contains the policy.
POLICY_CATALOG_ID	TEXT	Internal/system-generated identifier for the database in which the policy resides.
POLICY_CATALOG	TEXT	Database to which the policy belongs.
POLICY_OWNER	TEXT	Name of the role that owns the policy.
POLICY_SIGNATURE	TEXT	Type signature of the policy’s arguments.
POLICY_RETURN_TYPE	TEXT	Return value data type.
POLICY_BODY	TEXT	Policy definition.
POLICY_COMMENT	TEXT	Comments entered for the policy (if any).
CREATED	TIMESTAMP_LTZ	Date and time when the policy was created.
LAST_ALTERED	TIMESTAMP_LTZ	Date and time when the policy was last altered.
DELETED	TIMESTAMP_LTZ	Date and time when the policy was dropped.
OWNER_ROLE_TYPE	TEXT	The type of role that owns the object, for example `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.

Usage notes¶

Latency for the view can 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.

Example¶

SELECT policy_name, policy_body, created
  FROM SNOWFLAKE.ACCOUNT_USAGE.JOIN_POLICIES
  WHERE policy_name='JP2' AND created LIKE '2024-11-26%';

Copy

+-------------+----------------------------------------------------------+-------------------------------+
| POLICY_NAME | POLICY_BODY                                              | CREATED                       |
|-------------+----------------------------------------------------------+-------------------------------|
| JP2         | CASE                                                     | 2024-11-26 11:22:54.848 -0800 |
|             |           WHEN CURRENT_ROLE() = 'ACCOUNTADMIN'           |                               |
|             |             THEN JOIN_CONSTRAINT(JOIN_REQUIRED => FALSE) |                               |
|             |           ELSE JOIN_CONSTRAINT(JOIN_REQUIRED => TRUE)    |                               |
|             |         END                                              |                               |
+-------------+----------------------------------------------------------+-------------------------------+