How do incremental loads work and how do you avoid duplicates?

Incremental loads process only new/changed data. Common patterns: - Watermark columns (updated_at) - CDC streams - Partition-based loads Avoid duplicates by using idempotent merges (upserts), stable keys, and exactly-once-like processing semantics where possible. Always support safe backfills.