Create zero-copy clones on Snowflake

Snowflake’s zero-copy cloning feature provides a convenient way to quickly take a “snapshot” of any table, schema, or database and create a derived copy of that object which initially shares the underlying storage. This can be extremely useful for creating instant backups that do not incur any additional costs (until changes are made to the cloned object).

In this video, we will review the high-level design of Snowflake, how that involves cloned objects, create a cloned database and review the impact on permissions.

▬▬▬▬▬▬ T I M E S T A M P S ⏰ ▬▬▬▬▬▬
0:00 - Intro
0:14 Understanding Cloned Objects
1:39 Create a Cloned Database
3:03 Cloning With Time Travel
4:22 Review Cloned Permissions
5:50 Review Cloned DDL
6:48 Closing

Useful Links:
- https://docs.snowflake.com/en/sql-reference/sql/create-clone.html
- https://docs.snowflake.com/en/user-guide/tables-storage-considerations.html#cloning-tables-schemas-and-databases
- https://docs.snowflake.com/en/sql-reference/constructs/at-before.html

Thank you for watching!

How to Create Zero Copy Clone Objects in Snowflake | Snowflake Tutorial
#snowflake #dataengineering

Видео Create zero-copy clones on Snowflake канала Kahan Data Solutions