Production-style SCD Type 1 data pipeline built with Snowflake and AWS S3, featuring automated ingestion via Snowpipe, change detection with Streams, and conditional orchestration using Tasks and stored procedures. Demonstrates warehouse-native ELT and dimensional modeling best practices.
aws snowflake data-engineering data-pipeline dimensional-modeling snowpipe scd-type-1 snowflake-tasks snowflake-streams
-
Updated
Jan 4, 2026 - PLpgSQL