# Incremental Load

> Copy only what is new since last time. Do not copy it all again.

**Field:** Data Engineering  
**Category:** Ingestion & Streaming  
**Also known as:** Incremental Ingestion, Delta Load, High-Water Mark

## Think of it like

You do not reread the whole book each night. You start from your bookmark.

## Definition

An incremental load copies only the rows that are new or changed since the last run. It keeps a mark of how far it got, often the latest updated time or the highest ID. The next run asks only for rows past that mark. A full load copies the whole table each time instead. Incremental loads are far faster on big tables.

## Example

The orders table has 50 million rows. Each hour, the job copies only the few thousand that changed.

## Example code

```sql
SELECT *
FROM orders
WHERE updated_at > '2026-11-15 23:00:00';
```

Ask only for rows changed after the mark the last run saved.

## Why it matters

Big tables cannot be copied in full every hour. An incremental load keeps the job small and fast.

## Common mistake

Using an updated time that the app does not always set. Rows changed without it are never picked up.

## Three principles

- **Keep a mark.** Save how far the last run got.
- **Ask past the mark.** Only new or changed rows.
- **Deletes need care.** A deleted row has no new time.

## Related terms

- [Data Ingestion](https://learn.benibix.com/term/data/data-ingestion)
- [Change Data Capture (CDC)](https://learn.benibix.com/term/data/change-data-capture)
- [Data Backfill](https://learn.benibix.com/term/data/data-backfill)
- [Batch Processing](https://learn.benibix.com/term/data/batch-processing)
- [Full Load](https://learn.benibix.com/term/data/full-load)
- [Incremental Model (dbt)](https://learn.benibix.com/term/data/incremental-model)

## Told apart from

- [Change Data Capture vs Incremental Load](https://learn.benibix.com/compare/change-data-capture-vs-incremental-load): People think asking a table for rows with a newer time is CDC. That is an incremental load. It asks the table on a timer and only sees rows as they are now. CDC reads the database's change log, so it catches every change, deletes too, within seconds.
- [Full Load vs Incremental Load](https://learn.benibix.com/compare/full-load-vs-incremental-load): People think an incremental load gives the same result as a full load, only faster, and it does not. A full load copies every row, so the copy always matches. An incremental load copies only rows past a marker, such as a time stamp. A row deleted at the source never passes that marker, so it stays in the copy. Many teams run both: small loads each night and a full one now and then.

---

Source: https://learn.benibix.com/term/data/incremental-load
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-19
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
