Snowflake Tutorial - Snowflake Stream & Change Data Capture | Chapter-17 | Snowflake Hands-on Tutorial

Snowflake Stream & Change Data Capture | Chapter-17 | Snowflake Hands-on Tutorial Snowflake Stream & Change Data Capture is coolest feature snowflake has to simplify the CDC architecture. This episode is a quick 25min introduction as well as feature elaboration to the stream objects and it will help you to answer the following questions 1. How snowflake stream works? 2. How snowflake stream (cdc) track changes? 3. What is offset in snowflake stream? 4. Does stream cost a lot? 5. How long stream hold the CDC data set? So enjoy this video series and provide your valuable feedback. 🌐 Site: https://toppertips.com 🚀 🚀 Chapters 🚀 🚀 ----------------------------------------- ➥ 00:00 What you don't know about snowflake streams? ➥ 01:29 Episode introduction ➥ 02:01 What is stream and how does it work? ➥ 04:00 Type of stream in snowflake ➥ 04:56 Can I create multiple stream on a source table ➥ 05:38 Can I clone a stream ➥ 06:11 What is offset and how it works in snowflake? ➥ 09:25 Why should I subscribe to Data Engineering Simplified YouTube channel ➥ 10:20 Snowflake Stream Hands on live session ➥ 10:29 Scenario-1 Stream on standard table ➥ 16:43 Scenario-2 Append Only Stream ➥ 18:59 Scenario-3 Stream on transient table ➥ 20:56 Scenario-4 Data Retention Period for Time Travel & Stream Objects ➥ 22:23 Scenario-5 How to consume stream data ➥ 22:23 Scenario-6 Stream on external table ➥ 24:18 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 #CDC #changeDataCaptureSnowflake #SnowflakeStream #snowflakeclone #snowflakecomputing #securedatasharing 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.