📥Incremental Load
Also known as Incremental Ingestion, Delta Load, High-Water Mark
Copy only what is new since last time. Do not copy it all again.
Think of it like
You do not reread the whole book each night. You start from your bookmark.
Example
The orders table has 50 million rows. Each hour, the job copies only the few thousand that changed.
Why it matters
Big tables cannot be copied in full every hour. An incremental load keeps the job small and fast.
Definition
Example code
sql
SELECT *
FROM orders
WHERE updated_at > '2026-11-15 23:00:00';Common mistake
Key takeaways
- 1Keep a mark. Save how far the last run got.
- 2Ask past the mark. Only new or changed rows.
- 3Deletes need care. A deleted row has no new time.