[Solved] Given this dbt incremental model SQL snippet:SELECT id, event_date, data_value FROM source_table WHERE event_date >= (SELECT MAX(event_date) FROM {{ this }})What is the main purpose of this WHERE... | dbt

dbt - Incremental Models

Given this dbt incremental model SQL snippet:

SELECT
  id,
  event_date,
  data_value
FROM source_table
WHERE event_date >= (SELECT MAX(event_date) FROM {{ this }})

What is the main purpose of this WHERE clause?

ATo select only new or updated data since last run

BTo select all data including duplicates

CTo exclude all late-arriving data

DTo select data with null event_date

Step-by-Step Solution

Solution:

Step 1: Analyze the WHERE clause logic
The clause filters rows where event_date is greater or equal to the max event_date already in the target table, meaning it picks new or updated data since last run.
Step 2: Understand incremental model behavior
This is a common pattern in dbt incremental models to avoid reprocessing old data and only add new or changed rows.
Final Answer:
To select only new or updated data since last run -> Option A
Quick Check:
Incremental filter = new or updated data [OK]

Quick Trick: Incremental models filter data newer than max existing date [OK]

Common Mistakes:

MISTAKES

Master "Incremental Models" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

Given this dbt incremental model SQL snippet: