- Course
- Data
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.
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.
Table of contents
About the author
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.