What is Snowflake Time Travel | Chapter-14 | Snowflake Hands-on Tutorial
Snowflake's Time Travel Feature is the most powerful and impactful utility, which, if used correctly and designed appropriately will save a lot of time and effort to simplify many complex data project operational activities. Time travel is not just limited to seeing the past state of your data, it brings a whole lot of new possibilities for the way design and operates data projects. This episode is a quick 30min introduction of time travel features and helps you to answer the following questions
1. What is time travel and how it works (conceptually)?
2. All editions of snowflake support time travel?
3. Time Travel and Fail-safe, both are the same?
4. How does time travel works for transient and temporary tables?
5. Does time travel cost a lot?
6. Time travel vs data retention parameters, are the same?
7. What is extended SQL for time travel?
8. Time Travel is applicable only for table or for DB as well as schema too?
So enjoy this video series and provide your valuable feedback.
🌐 Site: https://toppertips.com
🌐 SQL Scripts https://www.toppertips.com/snowflake-time-travel-feature
🚀 🚀 Chapters 🚀 🚀
-----------------------------------------
➥ 00:00 What problem does time-travel solve?
➥ 01:08 Episode introduction
➥ 01:53 Course Tree Map
➥ 02:50 Why to subscribe to this channel
➥ 03:44 What is time travel?
➥ 08:15 Time travel vs Fails Safe?
➥ 07:59 Time Travel for Transitent & Temp Tables
➥ 12:01 Time Travel Hands-on - How to enable time travel
➥ 19:36 Time Travel Hands-on - Drop & Undrop Table, Database, Schema
➥ 22:56 Time Travel Hands-on - Clone (Create Table) with Time Travel
➥ 26:31 Time Travel Hands-on - Create Table As Select[CTAS with Time Tavel]
➥ 27:17 Time Travel Hands-on - Table Storage Cost for Time Travel
➥ 29:28 Time Travel Hands-on - Time Travel + SnowSight
➥ 30:40 Thank you note
🚀 🚀 Snowflake Tutotorials (Beginners) All Episodes 🚀🚀
---------------------------------------------------------------------------------------------------
➥ Chapter 1-to-25 "Complete Playlist" 🌐 https://bit.ly/3iNTVGI
➥ Chapter-1 Snowflake Introduction & History 🌐 https://bit.ly/3xKHrna
➥ Chapter-2 Snowflake Free Trial Registration 🌐 https://bit.ly/3m6uiCL
➥ Chapter-3 Snowflake Architecture 🌐 https://bit.ly/3sk2fB2
➥ Chapter-4 Snowflake Classic or Legacy WebUI 🌐 https://bit.ly/3stSyzS
➥ Chapter-5 Snowflake SnowSight Modern WebUI 🌐 https://youtu.be/T-l_LN_505Q
➥ Chapter-6 Snowflake Unique Features 🌐 https://youtu.be/-MZrCpoAUs0
➥ Chapter-7 Snowflake DB/Schema/Table & Data Loading 🌐 https://youtu.be/Pi3z1NyBd-Y
➥ Chapter-8 Snowflake Must Know Database Objects 🌐 https://youtu.be/S5NwU2o2Exg
➥ Chapter-9 Snowflake Fast Data Loading/Ingestion 🌐 https://youtu.be/lI5OQPjuj-8
➥ Chapter-10 Snowflake Continuous Data Loading 🌐 https://youtu.be/PNK49SJvXjE
➥ Chapter-11 Snowflake External Table 🌐 https://youtu.be/w9BQsOlJc5s
➥ Chapter-12 Snowflake Virtual Warehouse 🌐 https://youtu.be/NE07Jx6V4UA
➥ Chapter-13 Snowflake Micro Partition 🌐 https://youtu.be/UNBysn1M9Vg
➥ Chapter-14 Snowflake Time Travel 🌐 https://youtu.be/9k8ADXunhIk
➥ Chapter-15 Snowflake Clone Feature 🌐 https://youtu.be/cAyM-Nj9WOc
➥ Chapter-16 Snowflake Secure Data Sharing 🌐 https://youtu.be/2d6d-zZMXtA
➥ Chapter-17 Snowflake Streams & Change Data Capture 🌐 https://youtu.be/DXI0GDSwE_E
➥ Chapter-18 Snowflake Task & Task Tree 🌐 https://youtu.be/165hXZ_o4Vk
➥ Chapter-19 ETL (Data Pipeline) in Snowflake 🌐 https://youtu.be/9FejjGVZrPg
➥ Chapter-20 Role, Grants & Role Hierarchy in Snowflake 🌐 https://youtu.be/pZQXK7qO0iY
➥ Chapter-21 (Part-1) Stored Procedure in Snowflake 🌐 https://youtu.be/CsH2sB6gwlw
➥ Chapter-21 (Part-2) User Defined Function in Snowflake 🌐https://youtu.be/xnjCbgu0Qj4
➥ Chapter-21 (Part-3) Snowflake Views (Standard, Secure & Materialized) 🌐 https://youtu.be/2soTybOZkXY
➥ Chapter-22 Snowflake Information Schema 🌐 https://youtu.be/kqZRXoFcKo0
➥ Chapter-23 Snowflake Resource Monitor 🌐 https://youtu.be/2msEUDzp-uU
➥ Chapter-24 (Part-1) Snowflake JDBC Driver 🌐 https://youtu.be/tzbqj2y_cbw
➥ Chapter-24 (Part-2) Snowflake ODBC Driver 🌐 https://youtu.be/X4uXkGS0dUQ
➥ Chapter-24 (Part-3) Snowflake Python Connector 🌐 https://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: https://youtu.be/jhNoKeB0CVY
➥ SnowPro Guide: https://bit.ly/35S7Rcb
➥ SnowPro Practice Test (60 Questions): https://bit.ly/2Ubernv
#timetravel #dropundrop #snowflakecomputing #snowflakeclustering #snowflakecompute #snowflaketimetravel #snowflakeedition
Видео What is Snowflake Time Travel | Chapter-14 | Snowflake Hands-on Tutorial канала Data Engineering Simplified
1. What is time travel and how it works (conceptually)?
2. All editions of snowflake support time travel?
3. Time Travel and Fail-safe, both are the same?
4. How does time travel works for transient and temporary tables?
5. Does time travel cost a lot?
6. Time travel vs data retention parameters, are the same?
7. What is extended SQL for time travel?
8. Time Travel is applicable only for table or for DB as well as schema too?
So enjoy this video series and provide your valuable feedback.
🌐 Site: https://toppertips.com
🌐 SQL Scripts https://www.toppertips.com/snowflake-time-travel-feature
🚀 🚀 Chapters 🚀 🚀
-----------------------------------------
➥ 00:00 What problem does time-travel solve?
➥ 01:08 Episode introduction
➥ 01:53 Course Tree Map
➥ 02:50 Why to subscribe to this channel
➥ 03:44 What is time travel?
➥ 08:15 Time travel vs Fails Safe?
➥ 07:59 Time Travel for Transitent & Temp Tables
➥ 12:01 Time Travel Hands-on - How to enable time travel
➥ 19:36 Time Travel Hands-on - Drop & Undrop Table, Database, Schema
➥ 22:56 Time Travel Hands-on - Clone (Create Table) with Time Travel
➥ 26:31 Time Travel Hands-on - Create Table As Select[CTAS with Time Tavel]
➥ 27:17 Time Travel Hands-on - Table Storage Cost for Time Travel
➥ 29:28 Time Travel Hands-on - Time Travel + SnowSight
➥ 30:40 Thank you note
🚀 🚀 Snowflake Tutotorials (Beginners) All Episodes 🚀🚀
---------------------------------------------------------------------------------------------------
➥ Chapter 1-to-25 "Complete Playlist" 🌐 https://bit.ly/3iNTVGI
➥ Chapter-1 Snowflake Introduction & History 🌐 https://bit.ly/3xKHrna
➥ Chapter-2 Snowflake Free Trial Registration 🌐 https://bit.ly/3m6uiCL
➥ Chapter-3 Snowflake Architecture 🌐 https://bit.ly/3sk2fB2
➥ Chapter-4 Snowflake Classic or Legacy WebUI 🌐 https://bit.ly/3stSyzS
➥ Chapter-5 Snowflake SnowSight Modern WebUI 🌐 https://youtu.be/T-l_LN_505Q
➥ Chapter-6 Snowflake Unique Features 🌐 https://youtu.be/-MZrCpoAUs0
➥ Chapter-7 Snowflake DB/Schema/Table & Data Loading 🌐 https://youtu.be/Pi3z1NyBd-Y
➥ Chapter-8 Snowflake Must Know Database Objects 🌐 https://youtu.be/S5NwU2o2Exg
➥ Chapter-9 Snowflake Fast Data Loading/Ingestion 🌐 https://youtu.be/lI5OQPjuj-8
➥ Chapter-10 Snowflake Continuous Data Loading 🌐 https://youtu.be/PNK49SJvXjE
➥ Chapter-11 Snowflake External Table 🌐 https://youtu.be/w9BQsOlJc5s
➥ Chapter-12 Snowflake Virtual Warehouse 🌐 https://youtu.be/NE07Jx6V4UA
➥ Chapter-13 Snowflake Micro Partition 🌐 https://youtu.be/UNBysn1M9Vg
➥ Chapter-14 Snowflake Time Travel 🌐 https://youtu.be/9k8ADXunhIk
➥ Chapter-15 Snowflake Clone Feature 🌐 https://youtu.be/cAyM-Nj9WOc
➥ Chapter-16 Snowflake Secure Data Sharing 🌐 https://youtu.be/2d6d-zZMXtA
➥ Chapter-17 Snowflake Streams & Change Data Capture 🌐 https://youtu.be/DXI0GDSwE_E
➥ Chapter-18 Snowflake Task & Task Tree 🌐 https://youtu.be/165hXZ_o4Vk
➥ Chapter-19 ETL (Data Pipeline) in Snowflake 🌐 https://youtu.be/9FejjGVZrPg
➥ Chapter-20 Role, Grants & Role Hierarchy in Snowflake 🌐 https://youtu.be/pZQXK7qO0iY
➥ Chapter-21 (Part-1) Stored Procedure in Snowflake 🌐 https://youtu.be/CsH2sB6gwlw
➥ Chapter-21 (Part-2) User Defined Function in Snowflake 🌐https://youtu.be/xnjCbgu0Qj4
➥ Chapter-21 (Part-3) Snowflake Views (Standard, Secure & Materialized) 🌐 https://youtu.be/2soTybOZkXY
➥ Chapter-22 Snowflake Information Schema 🌐 https://youtu.be/kqZRXoFcKo0
➥ Chapter-23 Snowflake Resource Monitor 🌐 https://youtu.be/2msEUDzp-uU
➥ Chapter-24 (Part-1) Snowflake JDBC Driver 🌐 https://youtu.be/tzbqj2y_cbw
➥ Chapter-24 (Part-2) Snowflake ODBC Driver 🌐 https://youtu.be/X4uXkGS0dUQ
➥ Chapter-24 (Part-3) Snowflake Python Connector 🌐 https://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: https://youtu.be/jhNoKeB0CVY
➥ SnowPro Guide: https://bit.ly/35S7Rcb
➥ SnowPro Practice Test (60 Questions): https://bit.ly/2Ubernv
#timetravel #dropundrop #snowflakecomputing #snowflakeclustering #snowflakecompute #snowflaketimetravel #snowflakeedition
Видео What is Snowflake Time Travel | Chapter-14 | Snowflake Hands-on Tutorial канала Data Engineering Simplified
Показать
Комментарии отсутствуют
Информация о видео
3 января 2022 г. 19:30:01
00:31:13
Другие видео канала
![Snowflake SQL Scripting - How To Use Variables | Snowflake Stored Procedure | Ch-06](https://i.ytimg.com/vi/U2gbypinWZs/default.jpg)
![JSON SQL Functions - Parse_JSON, Try_Parse_JSON & Check_JSON | Ch-09 | Snowflake JSON Tutorial](https://i.ytimg.com/vi/OU7UrljuvUI/default.jpg)
![Working With CURSOR Object | Snowflake Scripting Developer Guide | Stored Procedure Tutorial | Ch-15](https://i.ytimg.com/vi/MIy3k5SzqYk/default.jpg)
![Have you ever used change track table property in snowflake?](https://i.ytimg.com/vi/cNWRefIxXpw/default.jpg)
![#9 | IS_GRANTED_INVOKER_ROLE Context Function | Snowflake SQL Tutorial](https://i.ytimg.com/vi/B9cbE77lflU/default.jpg)
![#06 | Snowpark API For Java & Scala Vs. Python](https://i.ytimg.com/vi/WlRN7B7Rl4c/default.jpg)
![Ep-006 | Why Developer Must Have Monitor Privilege On Warehouse? | #shorts](https://i.ytimg.com/vi/nhcwJJcEyZ8/default.jpg)
![What Is Conditional Dynamic Data Masking In Snowflake | Part-02](https://i.ytimg.com/vi/l5zZPSsWTkQ/default.jpg)
![Column Level Security In Snowflake | Dynamic Data Masking In Snowflake](https://i.ytimg.com/vi/7YKQuKKcruo/default.jpg)
![Tag Based Dynamic Data Masking In Snowflake | Part-03](https://i.ytimg.com/vi/80l8943gGk0/default.jpg)
![How To Use CASE/WHEN Conditional Logic - SQL Scripting | Snowflake Stored Procedure Tutorial | Ch-11](https://i.ytimg.com/vi/oRzIqDvhyWU/default.jpg)
![#6 | Last Query ID Context Functions | Snowflake SQL Tutorial](https://i.ytimg.com/vi/jihqV0SjtPw/default.jpg)
![Snowflake Python Connector | Snowflake Hands-on Tutorial | Ep 24.3/27](https://i.ytimg.com/vi/ZrhTYKuGFbo/default.jpg)
![Drivers & Ecosystem Tools Snowpro Certification | Snowflake Certification Practice Test | #27](https://i.ytimg.com/vi/sD1wmGEnx3g/default.jpg)
![Snowflake Infer Schema For JSON Data | Automatically Load JSON Data Into Snowflake](https://i.ytimg.com/vi/a4ndsoZ5Ox8/default.jpg)
![Does Snowflake Support Local Table | Standard Table Vs. Local Table In Snowflake](https://i.ytimg.com/vi/mjXm9S-sIx4/default.jpg)
![Time Travel & Fail Safe Certification 30 Questions | Snowflake Certification Practice Test | #14](https://i.ytimg.com/vi/AdESTexG7QA/default.jpg)
![#5 | Current & Last Transaction Context Functions | Snowflake SQL Tutorial](https://i.ytimg.com/vi/vW5vScTJfbw/default.jpg)
![#04 | Where To Learn Snowpark From?](https://i.ytimg.com/vi/5bvWjlMqnDY/default.jpg)
![Snowflake Cost Optimization Strategies | 7 Tips To Reduce Your Snowflake Costs](https://i.ytimg.com/vi/kbuv4HHVeSk/default.jpg)
![Part-2 of Domain-2 Snowpro Core Certification Questions | COF-C02 Practice Test & MCQs | #05](https://i.ytimg.com/vi/lxZqD2_F2ms/default.jpg)