STORAGE_LIFECYCLE_POLICIES view¶

This Organization Usage view displays storage lifecycle policies.

Columns¶

Column name	Data type	Description
ORGANIZATION_NAME	TEXT	Name of the organization.
ACCOUNT_LOCATOR	TEXT	Locator for the account.
ACCOUNT_NAME	TEXT	Name of the account.
NAME	TEXT	Name of the storage lifecycle policy.
ID	NUMBER	Internal/system-generated identifier for the storage lifecycle policy.
SCHEMA_ID	TEXT	Internal/system-generated identifier for the schema in which the policy resides.
SCHEMA	TEXT	Schema to which the storage lifecycle policy belongs.
DATABASE_ID	TEXT	Internal/system-generated identifier for the database in which the policy resides.
DATABASE	TEXT	Database to which the storage lifecycle policy belongs.
OWNER	TEXT	Name of the role that owns the storage lifecycle policy.
SIGNATURE	TEXT	Type signature of the storage lifecycle policy’s arguments.
RETURN_TYPE	TEXT	Return value data type.
BODY	TEXT	Storage lifecycle policy definition.
COMMENT	TEXT	Comments entered for the storage lifecycle policy (if any).
CREATED_ON	TIMESTAMP_LTZ	Date and time when the storage lifecycle policy was created.
LAST_ALTERED_ON	TIMESTAMP_LTZ	Date and time when the storage lifecycle policy was last altered.
DELETED_ON	TIMESTAMP_LTZ	Date and time when the storage lifecycle policy was dropped.
OWNER_ROLE_TYPE	TEXT	The type of role that owns the object, either ROLE or DATABASE_ROLE.
OPTIONS	OBJECT	Storage lifecycle policy options, including ARCHIVE_FOR_DAYS (number of days to keep data in current tier) and ARCHIVE_TIER (target storage tier).