An incremental model processes only the new or modified rows on each run, instead of rebuilding the whole table. It reduces time and cost on large volumes. The first run builds the complete table; subsequent ones add or update only the delta.
Example
{{ config(materialized='incremental', unique_key='id') }}