Загрузка страницы

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
Показать
Комментарии отсутствуют
Введите заголовок:

Введите адрес ссылки:

Введите адрес видео с YouTube:

Зарегистрируйтесь или войдите с
Информация о видео
3 января 2022 г. 19:30:01
00:31:13
Другие видео канала
Snowflake SQL Scripting - How To Use Variables | Snowflake Stored Procedure | Ch-06Snowflake SQL Scripting - How To Use Variables | Snowflake Stored Procedure | Ch-06JSON SQL Functions - Parse_JSON, Try_Parse_JSON & Check_JSON | Ch-09 | Snowflake JSON TutorialJSON SQL Functions - Parse_JSON, Try_Parse_JSON & Check_JSON | Ch-09 | Snowflake JSON TutorialWorking With CURSOR Object | Snowflake Scripting Developer Guide | Stored Procedure Tutorial | Ch-15Working With CURSOR Object | Snowflake Scripting Developer Guide | Stored Procedure Tutorial | Ch-15Have you ever used change track table property in snowflake?Have you ever used change track table property in snowflake?#9 |  IS_GRANTED_INVOKER_ROLE Context Function | Snowflake SQL Tutorial#9 | IS_GRANTED_INVOKER_ROLE Context Function | Snowflake SQL Tutorial#06 |  Snowpark API For Java & Scala Vs. Python#06 | Snowpark API For Java & Scala Vs. PythonEp-006 | Why Developer Must Have Monitor Privilege On Warehouse?  | #shortsEp-006 | Why Developer Must Have Monitor Privilege On Warehouse? | #shortsWhat Is Conditional Dynamic Data Masking In Snowflake | Part-02What Is Conditional Dynamic Data Masking In Snowflake | Part-02Column Level Security In Snowflake | Dynamic Data Masking In SnowflakeColumn Level Security In Snowflake | Dynamic Data Masking In SnowflakeTag Based Dynamic Data Masking In Snowflake | Part-03Tag Based Dynamic Data Masking In Snowflake | Part-03How To Use CASE/WHEN Conditional Logic - SQL Scripting | Snowflake Stored Procedure Tutorial | Ch-11How To Use CASE/WHEN Conditional Logic - SQL Scripting | Snowflake Stored Procedure Tutorial | Ch-11#6 | Last Query ID Context Functions | Snowflake SQL Tutorial#6 | Last Query ID Context Functions | Snowflake SQL TutorialSnowflake Python Connector | Snowflake Hands-on Tutorial | Ep 24.3/27Snowflake Python Connector | Snowflake Hands-on Tutorial | Ep 24.3/27Drivers & Ecosystem Tools Snowpro Certification | Snowflake Certification Practice Test | #27Drivers & Ecosystem Tools Snowpro Certification | Snowflake Certification Practice Test | #27Snowflake Infer Schema For JSON Data | Automatically Load JSON Data Into SnowflakeSnowflake Infer Schema For JSON Data | Automatically Load JSON Data Into SnowflakeDoes Snowflake Support Local Table | Standard Table Vs. Local Table In SnowflakeDoes Snowflake Support Local Table | Standard Table Vs. Local Table In SnowflakeTime Travel & Fail Safe Certification 30 Questions | Snowflake Certification Practice Test | #14Time Travel & Fail Safe Certification 30 Questions | Snowflake Certification Practice Test | #14#5 | Current & Last Transaction Context Functions | Snowflake SQL Tutorial#5 | Current & Last Transaction Context Functions | Snowflake SQL Tutorial#04 |  Where To Learn Snowpark From?#04 | Where To Learn Snowpark From?Snowflake Cost Optimization Strategies | 7 Tips To Reduce Your Snowflake CostsSnowflake Cost Optimization Strategies | 7 Tips To Reduce Your Snowflake CostsPart-2 of Domain-2 Snowpro Core Certification Questions | COF-C02 Practice Test & MCQs | #05Part-2 of Domain-2 Snowpro Core Certification Questions | COF-C02 Practice Test & MCQs | #05
Яндекс.Метрика