- Schema:
STORAGE_LIFECYCLE_POLICY_HISTORY 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 the aggregated execution history of storage lifecycle policies. This view shows historical data from the past 12 months and only includes policy executions that have completed successfully or with failures. The view doesn’t include queued, currently executing, or cancelled policy executions.
Each row in this view corresponds to a different storage lifecycle policy execution.
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 |
|---|---|---|
POLICY_DB |
VARCHAR |
The name of the database that contains the storage lifecycle policy. |
POLICY_SCHEMA |
VARCHAR |
The name of the schema that contains the storage lifecycle policy. |
POLICY_NAME |
VARCHAR |
The name of the storage lifecycle policy. |
REF_ENTITY_DB |
VARCHAR |
The name of the database that contains the object that the storage lifecycle policy is attached to. |
REF_ENTITY_SCHEMA |
VARCHAR |
The name of the schema that contains the object that the storage lifecycle policy is attached to. |
REF_ENTITY_NAME |
VARCHAR |
The name of the object that the storage lifecycle policy is attached to. |
REF_ENTITY_DOMAIN |
VARCHAR |
The domain (type) of the object that the storage lifecycle policy is attached to; for example, Table. |
STATE |
VARCHAR |
The aggregated state of the storage lifecycle policy execution: SUCCEEDED or FAILED (completed executions only). |
START_TIME |
TIMESTAMP_LTZ |
Earliest timestamp of when any task in the storage lifecycle policy execution started. |
END_TIME |
TIMESTAMP_LTZ |
Latest timestamp of when any task in the storage lifecycle policy execution completed. |
EXECUTION_RESULT |
VARIANT |
JSON object containing detailed results for each task type in the storage lifecycle policy execution. The object can be of type EXPIRE, ARCHIVE, or EXPIRE_ARCHIVE ARCHIVE. Each nested object contains: start_time, end_time, state, and error details. |
POLICY_BODY |
VARCHAR |
The body of the storage lifecycle policy. |
Usage notes¶
Latency for the view may be up to 24 hours.
The view contains historical data for the past 12 months (one year).
The view only shows completed policy executions. It doesn’t include queued, currently executing, or cancelled policy executions.