"The concept of a Snowflake Storage Lifecycle Policy is well-established within the realm of cloud computing. This process has long been utilized by major cloud storage providers. Essentially, it involves a set of procedures and policies designed to manage data archival and retention. When data reaches a predefined archival threshold, it is transferred to more cost-effective storage within Snowflake. Eventually, the data expires and is moved to Snowflake's purging cycle, ensuring efficient and economical storage management."
"Snowflake Storage Lifecycle Policy Storage Lifecycle Policy triggers every 24 hours. When establishing a storage lifecycle policy, you have the option to define an archival period (in days). If specified, Snowflake transfers table rows that align with the policy expression to a more cost-effective storage tier for the designated duration before ultimately expiring the rows. Additionally, Snowflake activates change tracking on any tables associated with the policy.Once rows are archived to a lower-cost storage tier, they can no longer be directly queried."
Businesses accumulate large volumes of data over time, sometimes due to compliance or negligence. Snowflake storage is cheaper but still incurs costs. Without archival processes, storage costs can grow substantially. A storage lifecycle policy automatically archives table rows that meet a policy expression to a lower-cost tier and later expires them into Snowflake's purging cycle. Policies trigger every 24 hours and can specify archival periods in days. Applying a policy activates change tracking on affected tables. Archived rows cannot be directly queried but remain preserved for the defined archival duration.
Read at Medium
Unable to calculate read time
Collection
[
|
...
]