Design idempotent, incremental ETL/ELT SQL with change capture, deduplication, upserts, and late-arriving-data handling for a data pipeline.
## CONTEXT I am building or fixing a data pipeline in 2026 that loads data from sources into a warehouse or analytics database. I will describe the sources, the target tables, the load frequency, and the freshness requirement. I want incremental, idempotent ELT/ETL SQL that captures only changed data, deduplicates…
Premium Prompt
Unlock this prompt — and all 30,000+ expert-crafted prompts — with Pro.
Unlock with Pro