MHP

Snowflake Tasks & Streams

Native scheduling and change data capture for production pipelines
Streams (CDC)
Track DML changes (INSERT/UPDATE/DELETE)
Incremental processing: load only new data
Standard, append-only, and changes types
Tasks
Serverless or warehouse-based scheduling
Cron expressions & task graph DAGs
TASK_HISTORY() for execution monitoring
Stored Procedures
Snowflake Scripting & JavaScript
Modular pipeline logic with error handling
Callable from Tasks for automated runs

Streams + Tasks = incremental pipeline: Streams detect new data → Tasks process on schedule → Gold tables auto-refresh