Road to Snowflake SnowPro Core Certification: Time Travel, Fail-Safe & Zero-Copy Cloning

Thirteenth Chapter: Time Travel, Fail-Safe & Zero-Copy Cloning

Gonzalo Fernandez Plaza

--

Snowflake chapter about Time Travel, Fail-Safe, and Zero Copy Cloning.
Snowflake chapter about Time Travel, Fail-Safe, and Zero Copy Cloning.

So far, we have seen many features that make Snowflake an attractive service, but the features we will see in this chapter make Snowflake unique! Let’s look at the Snowflake storage feature (Time Travel, Fail-Safe & Zero Copy Cloning), and you’ll understand why Snowflake is getting increasingly popular lately!

  1. Introduction to Snowflake Storage Features
  2. Time Travel
  3. Restore Objects using Time Travel
  4. Querying over Historical Data using Time Travel
  5. Fail-Safe
  6. Zero-Copy Cloning
  7. Typical Exam Questions

Remember that all the chapters from the course can be found in the following link:

INTRODUCTION TO SNOWFLAKE STORAGE FEATURES

Have you ever seen the meme (I hope it hasn’t happened to you) where you start working at 9 a.m. on a Monday, and you delete a table in a production environment? Well, this will no longer be a problem, thanks to Snowflake!

In the following diagram, we can see different ways to recover data in Snowflake, first by ourselves using the Time Travel functionality, then by Snowflake support using the Fail-Safe retention period. Let’s study these concepts!

Recovering data using Snowflake (via docs.snowflake.com).
Recovering data using Snowflake (via docs.snowflake.com).

TIME TRAVEL

Time travel enables accessing historical data (i.e., data that has been changed or deleted) at any point within a defined period. If we drop a table, we can restore it with time travel. You can use it with Databases, Schemas & Tables.

--

--

Gonzalo Fernandez Plaza

Computer Science Engineer & Tech Lead 🖥️. Publishing AWS & Snowflake ❄️ courses & exams. https://www.fullcertified.com