dbt · Incremental Models & Performance

What is --full-refresh?

Mediumfull-refreshincrementalcli

Interview question

What does dbt --full-refresh do for incremental models?

How to answer

The short answer

--full-refresh forces dbt to rebuild incremental (and some other) models from scratch instead of applying a delta.

Shell
dbt run --full-refresh --select fct_orders
dbt build --full-refresh --select fct_orders

Effect on incremental models

is_incremental() evaluates to false during a full refresh, so your historical filter is skipped and the whole dataset is rebuilt.

When you need it

  • Logic change that must rewrite old rows (new columns, fixed join bug)
  • Bad data landed and merges cannot easily repair history
  • Changing unique_key or incremental strategy
  • that incremental apply cannot reconcile

Cost

Full refresh on a multi-terabyte fact can be expensive and long-running. Teams often full-refresh only selected models, or rebuild a bounded window instead.

Interview tip: "Incremental is the happy path; --full-refresh is the rebuild lever when history must be rewritten."

Two guards worth knowing

--full-refresh also drops and recreates seeds, so a build with the flag can reload every seed in the selection. And a very large can protect itself with a config, so nobody rebuilds it by accident:

SQL
{{ config(materialized='incremental', unique_key='order_id', full_refresh=false) }}

With full_refresh=false, passing --full-refresh does not rebuild that model. To rebuild it on purpose, change the config in a reviewed pull request first. Without a guard like this, one forgotten flag in a scheduled job can rebuild a table that normally takes minutes in hours.