Explanation
Why the waste happens and who it affects.
Without lifecycle policies or regular purging, tables accumulate outdated data.
Retaining large volumes of inactive or irrelevant data increases storage costs, and because warehouse compute is billed per second of runtime by warehouse size, scanning unneeded data can lengthen queries and increase credit consumption unnecessarily.
Billing model
The pricing dimensions that drive this cost.
- Storage is billed monthly at a flat rate per TB of compressed data, which depends on account type (Capacity or On Demand) and region; stale rows in active tables are billed for as long as they are kept
- Deleted or updated rows in permanent tables remain billed through their Time Travel retention period and 7 days of Fail-safe, so purging reduces storage charges only after those windows pass
- Warehouse compute is billed in credits per second while running (with a 60-second minimum each time a warehouse starts or resumes), at a rate set by warehouse size, so scanning unneeded data lengthens queries and consumes more credits
- Rows moved by a storage lifecycle policy to the COOL or COLD archive tiers are billed at lower storage rates, with minimum archival periods of 90 days (COOL) and 180 days (COLD)
How to detect
4 checks to find it in your estate.
- Review table size growth trends over time to identify tables accumulating data without regular trimming
- Analyze access patterns (for example with the ACCESS_HISTORY view, which requires Enterprise Edition) 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
How to fix
5 ways to remove the waste.
- 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)
- Use Snowflake storage lifecycle policies to automatically expire rows past the retention window or archive them to the COOL or COLD storage tiers
- 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
Documentation
Vendor references for pricing and configuration.
