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 🌐    • Snowsight - Snowflake Modern Web UI |...  
➥ Chapter-6 Snowflake Unique Features 🌐    • Snowflake Unique Features | Chapter-6...  
➥ Chapter-7 Snowflake DB/Schema/Table & Data Loading 🌐    • Snowflake Database/Schema/Table & Con...  
➥ Chapter-8 Snowflake Must Know Database Objects 🌐    • Snowflake Must Know New Objects  | Ch...  
➥ Chapter-9 Snowflake Fast Data Loading/Ingestion 🌐    • Fast Data Loading & Bulk Ingestion in...  
➥ Chapter-10 Snowflake Continuous Data Loading 🌐    • Continuous Data Loading & Data Ingest...  
➥ Chapter-11 Snowflake External Table 🌐    • How to work with external table in Sn...  
➥ Chapter-12 Snowflake Virtual Warehouse 🌐    • How To Work With Snowflake Virtual Wa...  
➥ Chapter-13 Snowflake Micro Partition 🌐    • #13 | Micro Partitions & Data Cluster...  
➥ Chapter-14 Snowflake Time Travel 🌐    • What is Snowflake Time Travel | Chapt...  
➥ Chapter-15 Snowflake Clone Feature 🌐    • Snowflake Zero Copy Clone | Chapter-1...  
➥ Chapter-16 Snowflake Secure Data Sharing 🌐    • Snowflake Data Sharing | Chapter-16 |...  
➥ Chapter-17 Snowflake Streams & Change Data Capture 🌐    • Snowflake Stream & Change Data Captur...  
➥ Chapter-18 Snowflake Task & Task Tree 🌐    • Snowflake Tasks & Task Tree | Chapter...  
➥ Chapter-19 ETL (Data Pipeline) in Snowflake 🌐    • ETL Workflow In Snowflake | Chapter-1...  
➥ Chapter-20 Role, Grants & Role Hierarchy in Snowflake 🌐    • Role, Grants & Role Hierarchy In Snow...  
➥ Chapter-21 (Part-1) Stored Procedure in Snowflake 🌐    • Stored Procedure In Snowflake | Chapt...  
➥ Chapter-21 (Part-2) User Defined Function in Snowflake 🌐   • User Defined Functions In Snowflake |...  
➥ Chapter-21 (Part-3) Snowflake Views (Standard, Secure & Materialized) 🌐    • What are views in Snowflake  | Chapte...  
➥ Chapter-22 Snowflake Information Schema 🌐    • What Is Information Schema In Snowfla...  
➥ Chapter-23 Snowflake Resource Monitor 🌐    • What Is Resource Monitor In Snowflake...  
➥ Chapter-24 (Part-1) Snowflake JDBC Driver 🌐    • How to Use Snowflake Java JDBC Driver...  
➥ Chapter-24 (Part-2) Snowflake ODBC Driver 🌐    • Microsoft Excel & Snowflake ODBC Driv...  
➥ Chapter-24 (Part-3) Snowflake Python Connector 🌐    • Snowflake Python Connector | Snowflak...  
➥ 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:    • Видео  
➥ 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.