- Course
Access Historical Data with Time Travel in Snowflake
Snowflake’s Time Travel feature allows you to look at data at different moments in the past. This course will teach you the fundamentals of this feature and how to use it for analysis and recovery.
Intermediate
- Course
Access Historical Data with Time Travel in Snowflake
Snowflake’s Time Travel feature allows you to look at data at different moments in the past. This course will teach you the fundamentals of this feature and how to use it for analysis and recovery.
Intermediate
Get started today
Access this course and other top-rated tech content with one of our business plans.
Try this course for free
Access this course and other top-rated tech content with one of our individual plans.
This course is included in the libraries shown below:
- Data
What you'll learn
The Snowflake Cloud Data Platform has a powerful feature called Time Travel to access the history of data as it changes over time.
In this course, Access Historical Data with Time Travel in Snowflake, you’ll learn about using this feature to look at different versions of data at different moments in time and recover data that has been deleted or dropped.
First, you’ll explore what Time Travel is, its limitations, and what problems it solves. Next, you’ll discover the different query syntax clauses available to access data with Time Travel. Then, you'll use Time Travel to create clones of objects as they existed in a point in time in the past. Finally, you'll look at using Time Travel to recover dropped data.
When you’re finished with this course, you’ll have the skills and knowledge of accessing historical data with Time Travel in Snowflake.
Access Historical Data with Time Travel in Snowflake
Intermediate
Table of contents
Warner is a SQL Server Certified Master, MVP, and Principal Consultant at Pythian. He manages clients in many industries and leads a talented team that maintains and innovates with their data solutions. When he's not working in Ottawa, Ontario, he can be found in his home country of Costa Rica.