SESSION_POLICIES View¶

This Account Usage view provides the session policies in your account.

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

Columns¶

Column Name	Data Type	Description
NAME	TEXT	Name of the policy.
ID	NUMBER	Internal/system-generated identifier for the session policy.
NAME	TEXT	Name of the session policy.
SCHEMA_ID	TEXT	Internal/system-generated identifier for the schema in which the policy resides.
SCHEMA	TEXT	Schema to which the session policy belongs.
DATABASE_ID	TEXT	Internal/system-generated identifier for the database in which the policy resides.
DATABASE	TEXT	Database to which the session policy belongs.
OWNER	TEXT	Name of the role that owns the session policy.
OWNER_ROLE_TYPE	TEXT	The type of role that owns the object, either `ROLE` or `DATABASE_ROLE`. Note that Snowflake returns NULL if you delete the object because there is no owner role for a deleted object.
SESSION_IDLE_TIMEOUT_MINS	INT	Session idle timeout in minutes for the policy.
SESSION_UI_IDLE_TIMEOUT_MINS	INT	UI session idle timeout in minutes for the policy.
COMMENT	TEXT	Comments entered for the session policy (if any).
CREATED	TIMESTAMP_LTZ	Date and time when the session policy was created.
LAST_ALTERED	TIMESTAMP_LTZ	Date and time when the session policy was last altered.
DELETED	TIMESTAMP_LTZ	Date and time when the session policy was dropped.