Uploaded January 2022 | Updated September 2026, 2 hours ago
Snowflake's Clone Feature is the very and handy feature, which, if used correctly and designed appropriately will help many use cases for which a development team rely on data operation team. Cloning is not just limited to tables, clone can be applied to schemas, databases and many other objects within schemas. This episode is a quick 30min introduction of cloning (or so called zero copy clone) features and it will help you to answer the following questions
1. Clone and zero copy clone, both are same?
2. Does clone cost anything, if yes, how much and when?
3. How to clone an object?
4. What objects are not clonable?
5. What happens if I clone a pipe?
6. Can I clone internal stages or external tables?
So enjoy this video series and provide your valuable feedback.
🌐 Site: toppertips.com
🌐 SQL Scripts toppertips.com/snowflake-time-travel-feature
🚀 🚀 Chapters 🚀 🚀
-----------------------------------------
➥ 00:00 What you need to know about clone?
➥ 01:10 Episode introduction
➥ 02:07 Course Tree Map
➥ 03:24 What is cloning in snowflake.
➥ 05:45 Schema level clonable objects.
➥ 06:46 List of direct clonable objects?
➥ 07:23 Clone Feature Hands-on
➥ 07:35 Table cloning & Understand Zero Copy Clone Hands-on
➥ 12:50 Transient & Temporary Table Clone Hands-on
➥ 16:26 Object Dependency with Clone Hands-on
➥ 19:06 Clone External Table Hands-on
➥ 21:24 Clone File Format & Sequences Hands-on
➥ 23:10 Clone Pipe Objects Hands-on
➥ 26:16 Clone Stream Objects Hands-on
➥ 28:21 Clone Task Objects Hands-on
➥ 28:21 Clone A large database Hands-on
➥ 33:38 Thank you note
🚀 🚀 Snowflake Tutotorials (Beginners) All Episodes 🚀🚀
---------------------------------------------------------------------------------------------------
➥ Chapter 1-to-25 "Complete Playlist" 🌐 bit.ly/3iNTVGI
➥ Chapter-1 Snowflake Introduction & History 🌐 bit.ly/3xKHrna
➥ Chapter-2 Snowflake Free Trial Registration 🌐 bit.ly/3m6uiCL
➥ Chapter-3 Snowflake Architecture 🌐 bit.ly/3sk2fB2
➥ Chapter-4 Snowflake Classic or Legacy WebUI 🌐 bit.ly/3stSyzS
➥ Chapter-5 Snowflake SnowSight Modern WebUI 🌐 youtu.be/T-l_LN_505Q
➥ Chapter-6 Snowflake Unique Features 🌐 youtu.be/-MZrCpoAUs0
➥ Chapter-7 Snowflake DB/Schema/Table & Data Loading 🌐 youtu.be/Pi3z1NyBd-Y
➥ Chapter-8 Snowflake Must Know Database Objects 🌐 youtu.be/S5NwU2o2Exg
➥ Chapter-9 Snowflake Fast Data Loading/Ingestion 🌐 youtu.be/lI5OQPjuj-8
➥ Chapter-10 Snowflake Continuous Data Loading 🌐 youtu.be/PNK49SJvXjE
➥ Chapter-11 Snowflake External Table 🌐 youtu.be/w9BQsOlJc5s
➥ Chapter-12 Snowflake Virtual Warehouse 🌐 youtu.be/NE07Jx6V4UA
➥ Chapter-13 Snowflake Micro Partition 🌐 youtu.be/UNBysn1M9Vg
➥ Chapter-14 Snowflake Time Travel 🌐 youtu.be/9k8ADXunhIk
➥ Chapter-15 Snowflake Clone Feature 🌐 youtu.be/cAyM-Nj9WOc
➥ Chapter-16 Snowflake Secure Data Sharing 🌐 youtu.be/2d6d-zZMXtA
➥ Chapter-17 Snowflake Streams & Change Data Capture 🌐 youtu.be/DXI0GDSwE_E
➥ Chapter-18 Snowflake Task & Task Tree 🌐 youtu.be/165hXZ_o4Vk
➥ Chapter-19 ETL (Data Pipeline) in Snowflake 🌐 youtu.be/9FejjGVZrPg
➥ Chapter-20 Role, Grants & Role Hierarchy in Snowflake 🌐 youtu.be/pZQXK7qO0iY
➥ Chapter-21 (Part-1) Stored Procedure in Snowflake 🌐 youtu.be/CsH2sB6gwlw
➥ Chapter-21 (Part-2) User Defined Function in Snowflake 🌐youtu.be/xnjCbgu0Qj4
➥ Chapter-21 (Part-3) Snowflake Views (Standard, Secure & Materialized) 🌐 youtu.be/2soTybOZkXY
➥ Chapter-22 Snowflake Information Schema 🌐 youtu.be/kqZRXoFcKo0
➥ Chapter-23 Snowflake Resource Monitor 🌐 youtu.be/2msEUDzp-uU
➥ Chapter-24 (Part-1) Snowflake JDBC Driver 🌐 youtu.be/tzbqj2y_cbw
➥ Chapter-24 (Part-2) Snowflake ODBC Driver 🌐 youtu.be/X4uXkGS0dUQ
➥ Chapter-24 (Part-3) Snowflake Python Connector 🌐 youtu.be/ZrhTYKuGFbo
➥ Chapter-25 (Part-1) Snowflake & PowerBI Reporting 🌐 coming-soon
➥ Chapter-25 (Part-2) Snowflake & Tableau Reporting 🌐 coming-soon
🚀 🚀 Snowflake Certification Complete Guide & Question Dump 🚀 🚀
-----------------------------------------------------------------------------------------------------------------
➥ Revised Sep 2020 Syllabus: youtu.be/jhNoKeB0CVY
➥ SnowPro Guide: bit.ly/35S7Rcb
➥ SnowPro Practice Test (60 Questions): bit.ly/2Ubernv
#snowflakeclone #zerocopyclone #snowflakecomputing #snowflakeclustering #snowflakecompute #snowflakecloning #clonedatabase #cloneschema #clonepipe #clonestream #clonestages
Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.
Snowflake's Clone Feature is the very and handy feature, which, if used correctly and designed appropriately will help many use cases for which a development team rely on data operation team. Cloning is not just limited to tables, clone can be applied to schemas, databases and many other objects within schemas. This episode is a quick 30min introduction of cloning (or so called zero copy clone) features and it will help you to answer the following questions
1. Clone and zero copy clone, both are same?
2. Does clone cost anything, if yes, how much and when?
3. How to clone an object?
4. What objects are not clonable?
5. What happens if I clone a pipe?
6. Can I clone internal stages or external tables?
So enjoy this video series and provide your valuable feedback.
🌐 Site: toppertips.com
🌐 SQL Scripts toppertips.com/snowflake-time-travel-feature
🚀 🚀 Chapters 🚀 🚀
-----------------------------------------
➥ 00:00 What you need to know about clone?
➥ 01:10 Episode introduction
➥ 02:07 Course Tree Map
➥ 03:24 What is cloning in snowflake.
➥ 05:45 Schema level clonable objects.
➥ 06:46 List of direct clonable objects?
➥ 07:23 Clone Feature Hands-on
➥ 07:35 Table cloning & Understand Zero Copy Clone Hands-on
➥ 12:50 Transient & Temporary Table Clone Hands-on
➥ 16:26 Object Dependency with Clone Hands-on
➥ 19:06 Clone External Table Hands-on
➥ 21:24 Clone File Format & Sequences Hands-on
➥ 23:10 Clone Pipe Objects Hands-on
➥ 26:16 Clone Stream Objects Hands-on
➥ 28:21 Clone Task Objects Hands-on
➥ 28:21 Clone A large database Hands-on
➥ 33:38 Thank you note
🚀 🚀 Snowflake Tutotorials (Beginners) All Episodes 🚀🚀
---------------------------------------------------------------------------------------------------
➥ Chapter 1-to-25 "Complete Playlist" 🌐 bit.ly/3iNTVGI
➥ Chapter-1 Snowflake Introduction & History 🌐 bit.ly/3xKHrna
➥ Chapter-2 Snowflake Free Trial Registration 🌐 bit.ly/3m6uiCL
➥ Chapter-3 Snowflake Architecture 🌐 bit.ly/3sk2fB2
➥ Chapter-4 Snowflake Classic or Legacy WebUI 🌐 bit.ly/3stSyzS
➥ Chapter-5 Snowflake SnowSight Modern WebUI 🌐 youtu.be/T-l_LN_505Q
➥ Chapter-6 Snowflake Unique Features 🌐 youtu.be/-MZrCpoAUs0
➥ Chapter-7 Snowflake DB/Schema/Table & Data Loading 🌐 youtu.be/Pi3z1NyBd-Y
➥ Chapter-8 Snowflake Must Know Database Objects 🌐 youtu.be/S5NwU2o2Exg
➥ Chapter-9 Snowflake Fast Data Loading/Ingestion 🌐 youtu.be/lI5OQPjuj-8
➥ Chapter-10 Snowflake Continuous Data Loading 🌐 youtu.be/PNK49SJvXjE
➥ Chapter-11 Snowflake External Table 🌐 youtu.be/w9BQsOlJc5s
➥ Chapter-12 Snowflake Virtual Warehouse 🌐 youtu.be/NE07Jx6V4UA
➥ Chapter-13 Snowflake Micro Partition 🌐 youtu.be/UNBysn1M9Vg
➥ Chapter-14 Snowflake Time Travel 🌐 youtu.be/9k8ADXunhIk
➥ Chapter-15 Snowflake Clone Feature 🌐 youtu.be/cAyM-Nj9WOc
➥ Chapter-16 Snowflake Secure Data Sharing 🌐 youtu.be/2d6d-zZMXtA
➥ Chapter-17 Snowflake Streams & Change Data Capture 🌐 youtu.be/DXI0GDSwE_E
➥ Chapter-18 Snowflake Task & Task Tree 🌐 youtu.be/165hXZ_o4Vk
➥ Chapter-19 ETL (Data Pipeline) in Snowflake 🌐 youtu.be/9FejjGVZrPg
➥ Chapter-20 Role, Grants & Role Hierarchy in Snowflake 🌐 youtu.be/pZQXK7qO0iY
➥ Chapter-21 (Part-1) Stored Procedure in Snowflake 🌐 youtu.be/CsH2sB6gwlw
➥ Chapter-21 (Part-2) User Defined Function in Snowflake 🌐youtu.be/xnjCbgu0Qj4
➥ Chapter-21 (Part-3) Snowflake Views (Standard, Secure & Materialized) 🌐 youtu.be/2soTybOZkXY
➥ Chapter-22 Snowflake Information Schema 🌐 youtu.be/kqZRXoFcKo0
➥ Chapter-23 Snowflake Resource Monitor 🌐 youtu.be/2msEUDzp-uU
➥ Chapter-24 (Part-1) Snowflake JDBC Driver 🌐 youtu.be/tzbqj2y_cbw
➥ Chapter-24 (Part-2) Snowflake ODBC Driver 🌐 youtu.be/X4uXkGS0dUQ
➥ Chapter-24 (Part-3) Snowflake Python Connector 🌐 youtu.be/ZrhTYKuGFbo
➥ Chapter-25 (Part-1) Snowflake & PowerBI Reporting 🌐 coming-soon
➥ Chapter-25 (Part-2) Snowflake & Tableau Reporting 🌐 coming-soon
🚀 🚀 Snowflake Certification Complete Guide & Question Dump 🚀 🚀
-----------------------------------------------------------------------------------------------------------------
➥ Revised Sep 2020 Syllabus: youtu.be/jhNoKeB0CVY
➥ SnowPro Guide: bit.ly/35S7Rcb
➥ SnowPro Practice Test (60 Questions): bit.ly/2Ubernv
#snowflakeclone #zerocopyclone #snowflakecomputing #snowflakeclustering #snowflakecompute #snowflakecloning #clonedatabase #cloneschema #clonepipe #clonestream #clonestages
Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.
