What is the expected output when running an incremental model with this condition?

medium📝 Predict Output Q5 of 15

dbt - Incremental Models

{{ config(materialized='incremental') }}
select * from sales where order_date > (select max(order_date) from {{ this }})

Assuming the existing model has max order_date '2023-05-01' and source has orders up to '2023-05-10'.

AThe model will delete existing data

BAll orders including '2023-05-01' will be reloaded

COnly orders from '2023-05-02' to '2023-05-10' will be added

DNo new orders will be added

Step-by-Step Solution

Solution:

Step 1: Identify max order_date in existing data
Max order_date is '2023-05-01' in the current model.
Step 2: Apply filter condition
Query selects orders with order_date greater than '2023-05-01', so orders from '2023-05-02' to '2023-05-10' are added.
Final Answer:
Only orders from '2023-05-02' to '2023-05-10' will be added -> Option C
Quick Check:
Incremental adds only newer dates [OK]

Quick Trick: Incremental adds data after max existing date [OK]

Common Mistakes:

MISTAKES

Master "Incremental Models" in dbt

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More dbt Quizzes