Unused tables
The Unused tables optimization highlights tables that have not been used in > 120 days, causing potentially unnecessary storage spend. For these tables, you can save storage costs by deleting or archiving unused tables.
ℹ️
Note: This optimization follows Slingshot’s role-based access patterns and only shows unused tables to users if the table’s database is part of the user’s business org. If you have not assigned databases to business orgs, non-admins will be unable to access data for this optimization. For more information on assigning objects to business orgs, you can view the Org Management documentation.
Frequency of update
Daily @ 06:00
Fields in result
- Account Locator
- Region
- Table
- Schema
- Database
- Table size (TB)
- Monthly storage cost ($)
- Last access (days)
- Last access by
- Last update (days)
Why is this helpful?
Removing tables that are unused will save the user table storage costs.
FAQs
- What time period is considered for “no activity”?
- 120 days without the table being queried from
- What’s the difference between the last access and last update columns?
- Last access = last time the table was read / queried from
- Last update = last time the table was written to
- What can I do for data important to keep even though the table isn’t being actively used?
- Storing tables in an Iceberg table outside of Snowflake can reduce costs while still leaving the data accessible to Snowflake in case it does become needed in the future.
- Are all table types included?
- We only show base (standard) tables, meaning we are excluding external tables, dynamic tables, Iceberg tables, temporary tables, etc