Enqurious logo
Go back

Using streams for incremental data load in Snowflake

1 Scenario
1 Hour
masterclass poster
Industry
e-commerce
Skills
batch-etl
Tools
snowflake

Learning Objectives

Learn why incremental data load is a smarter and cheaper option for ETL
Implement incremental data load via Streams in Snowflake

Overview

Learn about the concept of Change data capture and try implementing the same in Snowflake

Prerequisites

  • Ability to ingest data using stages and COPY command
  • Knowledge of table types for storing data
  • Knowledge of DML actions like INSERT, UPDATE, DELETE in Snowflake