From the course: Intro to Snowflake for Devs, Data Scientists, Data Engineers
Join today to access over 24,700 courses taught by industry experts.
Time travel: Part 1 - Snowflake Tutorial
From the course: Intro to Snowflake for Devs, Data Scientists, Data Engineers
Time travel: Part 1
- We're about to learn about time travel in Snowflake, and I'll just give it to you straight. Time travel is a superpower. I've had data science jobs before where some data would get messed up, and then we'd have to recreate our tables from raw data and it would take forever. And at the end, we wouldn't always be able to get back to the pre-corrupted state. There'd be these weird, persistent differences we couldn't account for and we would never figure it out. If we'd been using Snowflake, we could have avoided those headaches because, as you'll see, Snowflake Time Travel lets you go back in time and recover the exact data in your table, schema, or database at a point in the recent past. It's kind of hard to fathom. To understand Time Travel, we have to understand data retention in Snowflake. If we run the command show tables and scroll to the right, we'll see a column called retention time. For a normal permanent table, the default retention time is one day. If you're on the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.