[Solved] Given this incremental model SQL snippet:select * from source_table where updated_at > (select max(updated_at) from {{ this }})What happens when you run dbt run without full refresh? | dbt

dbt - Incremental Models

Given this incremental model SQL snippet:

select * from source_table where updated_at > (select max(updated_at) from {{ this }})

What happens when you run dbt run without full refresh?

ANo rows are added because the filter is incorrect.

BThe entire table is dropped and rebuilt.

CAll rows from source_table are appended regardless of updated_at.

DOnly rows with updated_at newer than existing max are added.

Step-by-Step Solution

Solution:

Step 1: Understand incremental filter logic
The query selects rows where updated_at is greater than the max in the current table, so only new or updated rows are added.
Step 2: Confirm behavior without full refresh
Without full refresh, dbt appends only these filtered rows, not rebuilding the whole table.
Final Answer:
Only rows with updated_at newer than existing max are added. -> Option D
Quick Check:
Incremental adds only newer rows by filter [OK]

Quick Trick: Incremental filters new rows by max timestamp [OK]

Common Mistakes:

MISTAKES

Master "Incremental Models" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

Given this incremental model SQL snippet: