thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Data & Analytics · Intermediate

Time Travel

A Snowflake feature for querying, cloning or restoring data as it existed at any point within a retention period.

Definition

Retention is 1 day by default; Enterprise Edition and above allow up to 90 days for permanent tables, set with DATA_RETENTION_TIME_IN_DAYS. You can query with AT or BEFORE (TIMESTAMP, OFFSET or STATEMENT), restore dropped objects with UNDROP and clone historical states. Transient and temporary tables allow 0 or 1 day.

Example

SELECT * FROM orders AT(OFFSET => -3600);

Exam tip

Time Travel is user-accessible (1-90 days); Fail-safe is a further 7 days recoverable only by Snowflake Support.

Related terms