From the course: Advanced Snowflake: Deep Dive Cloud Data Warehousing and Analytics

Unlock this course with a free trial

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

Configuring data retention time

Configuring data retention time - Snowflake Tutorial

From the course: Advanced Snowflake: Deep Dive Cloud Data Warehousing and Analytics

Start my 1-month free trial Buy for my team

Configuring data retention time

“

- [Lecturer] In this demo, that'll span the next few videos, we'll work with time travel in Snowflake. Time Travel and Snowflake gives you access to historical data stored within your table within a certain time period. And this time period is referred to as the retention time period. Now I'm working within my production worksheet. I'm going to run a query to take a look at the metadata for my in production table. This is the table that I had created earlier in this course. When you look at this metadata, observe the retention time is set to one. This is the default retention time for a permanent table created in Snowflake. What does this retention time mean? Any changes you make to the data in this table will be backed up for a period of one day. And you can access historical data going back one day. You can actually change this retention time. Once the table has been created you can also specify it at the time of…

Contents