© Dmitry Anoshin, Dmitry Shirokov, Donna Strok 2020
D. Anoshin et al.Jumpstart Snowflakehttps://doi.org/10.1007/978-1-4842-5328-1_14

14. Time Travel

Dmitry Anoshin1 , Dmitry Shirokov2 and Donna Strok3
(1)
British Columbia, Canada
(2)
Burnaby, BC, Canada
(3)
Seattle, WA, USA
 
This chapter will cover the following tasks:
  • Working with previous versions of objects. In other words, Snowflake provides the ability to query historical data.

  • Creating copies/backups of data on the technical history of objects.

A specialty of the technical design of the Snowflake is that the data is stored in micro-partitions,1 which are immutable. This means that with any operations such as the addition or deletion of data, a new micro-partition is created, and the old one ceases to ...

Get Jumpstart Snowflake: A Step-by-Step Guide to Modern Cloud Analytics now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.