Industry
e-commerce
Skills
approach
Tools
snowflake
Learning Objectives
Capture real-time DML operations using Snowflake Streams for auditing and change data capture.
Automate the movement and transformation of incremental data using Snowflake Tasks.
Develop an end-to-end pipeline from source table to a processed target using only SQL scripting.
Understand the practical use of Streams and Tasks in modern data engineering scenarios.
Overview
Prerequisites
- Understanding of Snowflake tables and their types (permanent, transient, temporary).
- Knowledge of how to create and load data using stages in Snowflake.
- Familiarity with setting up storage integrations for accessing external cloud storage.
- Basic to intermediate understanding of SQL scripting and procedural logic in Snowflake.