Snowflake Time Travel

by Yana Arkhipenka

To empower your business decisions with data, you need Real-Time High-Quality data from all of your data sources in a central repository. Snowflake Time Travel is best feature suited for these purposes.

Time Travel is an interesting and useful tool that allows you to access data from any point of time in the past. It is an effective tool for doing the following tasks:

  • Restoring Data that has been changed or deleted in the past.
  • Duplicate or backing up Data from previous periods of time.
  • Analyzing Data Manipulation and Consumption over a set period of time.

To enable Snowflake Time Travel, no chores are necessary. It is turned on by default, with a one-day retention period. However, if you want to configure Longer Data Retention Periods of up to 90 days for Databases, Schemas, and Tables, you’ll need to upgrade to Snowflake Enterprise Edition.

How to query Snowflake Time Travel Data?