From the course: Snowflake SnowPro Core Cert Prep

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Underlying storage concepts

Underlying storage concepts - Snowflake Tutorial

From the course: Snowflake SnowPro Core Cert Prep

Start my 1-month free trial Buy for my team

Underlying storage concepts

“

So as I'm sure you starting to grasp in this file domain that brings everything together, using time travel and fail-safe requires versions of data to be stored in the background, which includes storage and not incurs a fee. So the amount of data required is calculated for each 24-hour period from when the data was changed. So that's based upon the number of days from when the data was modified, along with your data retention setting. So when you drop or truncate a table, entire copies of that data are held in time travel and fail-safe. If in other cases, Snowflake is intelligent enough to work out what data it needs to store to recover just the individual rows if required. So storage usage is then calculated as a percentage of the overall table size versus those records that have been modified. You can view the amount of storage used by fail-safe. You can go into the ACCOUNTADMIN role and head to the 'Billing and Usage' tab of the Account section in Snowflake in the classic web UI or…

Contents