You want to create a dbt incremental model that updates existing rows if data has changed and inserts new rows. Which strategy should you implement?

hard📝 Application Q8 of 15

dbt - Incremental Models

ARun a full refresh every time to replace the table

BSimply append all rows without filtering or updating existing data

Use <code>is_incremental()</code> with a <code>merge</code> or <code>update</code> statement to handle inserts and updates

DUse a view materialization instead of incremental

Step-by-Step Solution

Solution:

Step 1: Understand incremental update needs
To update existing rows and insert new ones, you need logic to merge changes.
Step 2: Use is_incremental() block
Within this block, implement SQL merge or update statements to handle changes.
Final Answer:
Use is_incremental() with a merge or update statement to handle inserts and updates -> Option C
Quick Check:
Use is_incremental() with merge/update for upserts [OK]

Quick Trick: Use is_incremental() with merge for updates and inserts [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