STORAGE_LIFECYCLE_POLICIES view¶

Important

This view is only available in the organization account. For more information, see Premium views in the organization account.

This Organization Usage view displays storage lifecycle policies in your organization.

Each row in this view corresponds to a different storage lifecycle policy.

Columns¶

Organization-level columns

Column Name	Data Type	Description
ORGANIZATION_NAME	VARCHAR	Name of the organization.
ACCOUNT_LOCATOR	VARCHAR	System-generated identifier for the account.
ACCOUNT_NAME	VARCHAR	User-defined identifier for the account.

Additional columns

Column Name	Data Type	Description
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).