Tasks and Streams

Overview

Tasks and Streams form the backbone of native data pipelines and Change Data Capture (CDC) architectures in Snowflake. Together, they allow you to automate data transformations based on schedules or incoming data changes without needing external orchestration tools like Airflow.

Key Concepts

Streams (Change Data Capture)

A Stream is a first-class Snowflake object that records data manipulation language (DML) changes made to a table, including inserts, updates, and deletes, as well as metadata about each change.