Hands-on tutorial to ingest CDC & Delta data using snowflake Stream & Task. This guide also helps you to understand how to ingest data continuously and transform it.
► Stream/Task Beginner's Guide: [ Ссылка ]
Video Chapter Quick Access Links
------------------------------------------------------------
► 00:00 - Introduction of Stream & Task Beginner's Guide
► 00:13 - Source Code & SQL Script - Where to find ([ Ссылка ])
► 00:39 - Who is this tutorial for?
► 01:20 - Quick theory about stream & task
► 03:00 - Data Flow Model for hands on excercise
► 05:48 - Stream & Task Metadata Columns
► 07:44 - Hands on Excercise In-Action
► 07:47 - Chapter-1 - Hands on excercise introduction
► 10:02 - Chapter-2 - Create Stage Object & Load sales data via SnowSQL
► 18:35 - Chapter-3 - Load product master data under common context + load data via snowflake UI
► 21:46 - Chapter-4 - Load sales data under raw & curated layer
► 26:37 - Chapter-5 - Stream in action (Most important chapter)
► 39:40 - Chapter-6 - Stream as Insert Only for CDC
► 44:14 - Chapter-7 - Task in Action & end-to-end data flow
► 51:31 - Summary Note
► 52:32 - Thanks Note & Other Reference
Complete Snowflake Certification Guide + Question Dump + Revised Syllabus
--------------------------------------------------------------------------------------------------------------------------
► Complete SnowPro Guide: [ Ссылка ]
🚀 🚀 Snowflake Tutotorials (Beginners) All Episodes 🚀🚀
---------------------------------------------------------------------------------------------------
➥ Chapter 1-to-25 "Complete Playlist" 🌐 [ Ссылка ]
➥ Chapter-1 Snowflake Introduction & History 🌐 [ Ссылка ]
➥ Chapter-2 Snowflake Free Trial Registration 🌐 [ Ссылка ]
➥ Chapter-3 Snowflake Architecture 🌐 [ Ссылка ]
➥ Chapter-4 Snowflake Classic or Legacy WebUI 🌐 [ Ссылка ]
➥ Chapter-5 Snowflake SnowSight Modern WebUI 🌐 [ Ссылка ]
➥ Chapter-6 Snowflake Unique Features 🌐 [ Ссылка ]
➥ Chapter-7 Snowflake DB/Schema/Table & Data Loading 🌐 [ Ссылка ]
➥ Chapter-8 Snowflake Must Know Database Objects 🌐 [ Ссылка ]
➥ Chapter-9 Snowflake Fast Data Loading/Ingestion 🌐 [ Ссылка ]
➥ Chapter-10 Snowflake Continuous Data Loading 🌐 [ Ссылка ]
➥ Chapter-11 Snowflake External Table 🌐 [ Ссылка ]
➥ Chapter-12 Snowflake Virtual Warehouse 🌐 [ Ссылка ]
➥ Chapter-13 Snowflake Micro Partition 🌐 [ Ссылка ]
➥ Chapter-14 Snowflake Time Travel 🌐 [ Ссылка ]
➥ Chapter-15 Snowflake Clone Feature 🌐 [ Ссылка ]
➥ Chapter-16 Snowflake Secure Data Sharing 🌐 [ Ссылка ]
➥ Chapter-17 Snowflake Streams & Change Data Capture 🌐 [ Ссылка ]
➥ Chapter-18 Snowflake Task & Task Tree 🌐 [ Ссылка ]
➥ Chapter-19 ETL (Data Pipeline) in Snowflake 🌐 [ Ссылка ]
➥ Chapter-20 Role, Grants & Role Hierarchy in Snowflake 🌐 [ Ссылка ]
➥ Chapter-21 (Part-1) Stored Procedure in Snowflake 🌐 [ Ссылка ]
➥ Chapter-21 (Part-2) User Defined Function in Snowflake 🌐[ Ссылка ]
➥ Chapter-21 (Part-3) Snowflake Views (Standard, Secure & Materialized) 🌐 [ Ссылка ]
➥ Chapter-22 Snowflake Information Schema 🌐 [ Ссылка ]
➥ Chapter-23 Snowflake Resource Monitor 🌐 [ Ссылка ]
➥ Chapter-24 Coming Soon, to be published shortly
➥ Chapter-25 Coming Soon , to be published shortly
#dataengineeringsimpliefied
#snowflakedatawrehouse
#snowprocertification
#snowflakecertification
#snowflakestream
#snowflaketask
#toppertips
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.
Ещё видео!