#####   ######  #####    ###    #   #  ###  #   #  ######
##  ##  ##      ##  ##  ## ##   #   #   #   #   #  ##
#####   ####    #####   #   #   #   #   #   #   #  ####
##  #   ##      ##      ## ##    # #    #    # #   ##
##   #  ######  ##       ###      #    ###    #    ######

$ curl repovive.com/roadmaps/data-engineer-interview-prep/cloud-data-warehouses/snowflake-time-travel-and-cloning

░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░█████████████████████████████████████████████████████████████████████████████████████████████████████████████████

#####   ######  #####    ###    #   #  ###  #   #  ######
##  ##  ##      ##  ##  ## ##   #   #   #   #   #  ##
#####   ####    #####   #   #   #   #   #   #   #  ####
##  #   ##      ##      ## ##    # #    #    # #   ##
##   #  ######  ##       ###      #    ###    #    ######

$ curl repovive.com/roadmaps/data-engineer-interview-prep/cloud-data-warehouses/snowflake-time-travel-and-cloning

Repovive

Snowflake Time Travel and Cloning - Cloud Data Warehouses | Data Engineer Interview Prep | Repovive

Repovive.

Data Engineer Interview Prep16 sections · 140 units8h total

Open in Course

Snowflake Time Travel and Cloning

Built-in data recovery

Time Travel lets you query data as it existed in the past:

SELECT * FROM orders
AT(TIMESTAMP => '2024-01-15 10:00:00'::timestamp);

Standard edition has fixed $1$ -day retention. Enterprise allows configuring retention from $1$ to $90$ days per table. Use it to recover from accidental deletes or debug data issues.

Zero-copy cloning: Create instant copies of tables, schemas, or databases without duplicating storage. Only changed data incurs cost. Perfect for creating dev/test environments from production.