Originally published on LinkedIn: https://www.linkedin.com/pulse/snowflake-caching-performance-explained-clear-story-mohapatra-p0ric/?trackingId=XOnrAVSWV7bM%2FOvYlOboOA%3D%3D Migrated on: 2026-04-05 The query result cache is essential for repeated query performance. By reusing the results of recently run queries, it drastically reduces both time and resource consumption. 🛠️ How It Works : If the exact query is repeated within 24 hours and no changes occur in the underlying data, Snowflake will return the cached result. This optimization can save significant compute costs in repetitive reporting environments. 👩💻 Real-World Example : A marketing analyst rerunning customer engagement reports throughout the day would experience much faster query response times due to the query result cache, thus streamlining the reporting process unless the underlying data has changed. Managing Warehouse Cache for Efficiency The warehouse cache stores data...

Originally published on LinkedIn: https://www.linkedin.com/pulse/nowflake-backup-data-recovery-key-concepts-arabinda-mohapatra-yvwfc/ Migrated on: 2026-04-05 What is Time Travel? Time Travel is like a time machine for your data. It allows you to go back to a specific point in the past and see or recover data as it was at that time. This is extremely useful when you need to undo accidental deletions or changes. 🔑 Key Insights: Retention Period : You can set how long Snowflake keeps past versions of your data. The default is 1 day, but in the Enterprise Edition or above, you can extend this up to 90 days. Easy Recovery : With Time Travel, you can query, restore, or clone data as it was at any point during the retention period. Rollback Mistakes : You can fix user errors by simply rolling back to a previous version of your table or database. 🚫 1. External Tables — Why They Are Not Cloned External tables only store m...