© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022
A. MortonMastering Snowflake Solutionshttps://doi.org/10.1007/978-1-4842-8029-4_5

5. Protecting Data in Snowflake

Adam Morton1  
(1)
Sydney, NSW, Australia
 

Not so long ago, protecting your data from accidental deletion or modification, hardware or software failure, or recovering the database after it was polluted by loading corrupt data into it was not a trivial affair.

Just to give you a flavor of the pain involved in protecting data, let’s open a window into the past. We’ll look at one key element, backing up data in a database.

To ensure you could roll back to a known position, you had to make database backups. These backups were cumbersome to deal with due ...

Get Mastering Snowflake Solutions: Supporting Analytics and Data Sharing 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.