AI Prompts

Prove a warehouse MERGE or upsert cannot duplicate keys, drop deletes, or race with concurrent writers under real source mutations.

Find overlapping intervals, missed closes, and point-in-time join bugs in a slowly changing dimension under corrections and late source rows.

Audit a change-data-capture pipeline for gaps, duplicates, reordering, and recovery risks.

Prove a dbt incremental model handles updates, late data, deletes, and full refreshes, with fixtures that would catch silent drift.