Here are seven specific responsibilities for a Data Steward that can lead to quick wins in optimizing your Snowflake storage costs.
1. Master Time Travel and Fail-Safe Settings
Snowflake’s Time Travel feature is a powerful tool for data recovery, but it comes at a cost, adding a 3-10% overhead to your storage. The Data Steward’s role is to define appropriate retention windows based on business needs, not just technical defaults. This ensures that you’re not paying for longer-than-necessary data history.
2. Enforce Data Lifecycle and Tiering Policies
With Snowflake Storage Lifecycle Policies becoming generally available in 2026, the Data Steward will be responsible for tagging data and ensuring it moves to COOL (67% savings) or COLD (90% savings) tiers. This is a massive opportunity for cost savings, but it requires careful planning and management.
3. Eliminate Zombie Assets: Prune Staged Files and Transient Tables
Temporary data that is no longer needed can quickly accumulate and drive up your storage costs. A Data Steward is responsible for creating and enforcing policies to clean up these “zombie assets,” such as staged files and transient tables.
4. Drive Storage Efficiency with Quality Checks
Poorly structured data can lead to bloated tables and inefficient storage. A Data Steward ensures that data is properly compressed and partitioned, which can lead to a 3-5x reduction in storage consumption. This not only saves money but also improves query performance.
5. Manage Metadata for Archiving and Offloading
Not all data needs to be stored in Snowflake. A Data Steward uses metadata to identify “cold” data that can be offloaded to cheaper storage like Amazon S3 or Glacier. This can be managed using a platinum/gold/bronze playbook, where data is tiered based on its value and access frequency.
6. Monitor Storage Usage Against Budgets
A Data Steward is responsible for actively monitoring storage dashboards and alerting Data Owners when costs approach budget limits. This proactive approach helps to prevent bill shock and ensures that you’re staying within your budget.
7. Govern Access to Prevent Unnecessary Data Proliferation
When users have broad access to data, they often create unnecessary copies of large datasets. A Data Steward helps to define and review access controls, preventing data proliferation and its associated storage costs. This also improves data security and compliance with regulations like GDPR/CCPA.