# Retention of Unused Data in Snowflake Table

Canonical: https://www.pointfive.co/efficiency-hub/inefficiencies/retention-of-unused-data-in-snowflake-table

[Cloud Efficiency Hub](https://www.pointfive.co/efficiency-hub) 

# Retention of Unused Data in Snowflake Table

## Explanation

Retention of stale data occurs when old, no longer needed records are preserved within active Snowflake tables. Without lifecycle policies or regular purging, tables accumulate outdated data.

Because Snowflake's compute charges are tied to how much data is scanned, retaining large volumes of inactive or irrelevant data can drive up both storage and query execution costs unnecessarily.

## Relevant Billing Model

## Detection

- Review table size growth trends over time to identify tables accumulating data without regular trimming

- Analyze access patterns to determine whether older records are being queried or accessed by active workloads

- Assess whether current business or regulatory requirements justify the retention period for older data

- Identify opportunities to implement lifecycle policies or manual purging for data beyond the necessary retention window

## Remediation

- Implement data retention policies to regularly archive or delete records older than the required retention period (e.g., retain only 90 days of data if historical lookbacks are not needed beyond that)

- Collaborate with business, analytics, and compliance teams to validate acceptable data retention thresholds

- Purge old records to reduce table storage size and improve query performance by minimizing unnecessary data scans

- Monitor table growth rates and periodically reassess lifecycle settings to ensure alignment with business needs

## Relevant Documentation

- [Unused Tables](https://select.dev/posts/snowflake-unused-tables)

- [Storage Lifecycle Policies](https://medium.com/snowflake/optimizing-costs-in-snowflake-with-effective-storage-lifecycle-policies-027dd98eaafd)

- [Access History](https://docs.snowflake.com/en/sql-reference/account-usage/access_history)

[Submit Feedback](https://hub.pointfive.co/inefficiencies/retention-of-unused-data-in-snowflake-table)

## At a glance

Reference

CER-0126

Cloud provider

Snowflake

Service

Snowflake Tables

Category

[Storage](https://www.pointfive.co/efficiency-hub/service-category/storage)

Inefficiency type

Excessive Data Retention

## Contributed by

- Simar Arora 

### Simar Arora

Value Engineer - FinOps @ Snowflake

[LinkedIn](https://www.linkedin.com/in/simarpreet-arora/)

---
Source: the public page above. Product screenshots and illustrative interfaces are examples, not live customer data.