Snowflake Stream & Task Hands On | Complete Beginners Tutorial | Step By Step Guide

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: https://toppertips.com/snowflake-stream-and-task-handson


Video Chapter Quick Access Links
------------------------------------------------------------
► 00:00 - Introduction of Stream & Task Beginner's Guide
► 00:13 - Source Code & SQL Script - Where to find (https://bit.ly/3nQYeAq)
► 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: https://www.youtube.com/playlist?list=PLba2xJ7yxHB5TAGUijLNQt-VR9iZJwcE7

? ? 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 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.