thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Data & Analytics · Intermediate

Incremental Load

Loading only data that is new or changed since the last run, instead of reloading everything.

Definition

Incremental loads use watermark columns, CDC, file-arrival tracking (Auto Loader, Snowpipe) or streams. They reduce cost and runtime but need logic for updates, deletes and late data.

Exam tip

Large tables with small daily changes call for incremental loads; a full reload is wasteful.

Related terms