dbt - Incremental Models
Which incremental strategy in dbt allows you to update existing rows and insert new rows based on a unique key?
Which incremental strategy in dbt allows you to update existing rows and insert new rows based on a unique key?
easy📝 Conceptual Q2 of 15
Step-by-Step Solution
Solution:
Step 1: Identify strategy that updates and inserts
The merge strategy updates existing rows and inserts new rows using a unique key.Step 2: Eliminate other options
Append only adds new rows, Delete + Insert replaces all data, Full Refresh rebuilds entire table.Final Answer:
Merge -> Option CQuick Check:
Update and insert rows = Merge [OK]
Quick Trick: Merge updates existing and adds new rows using keys [OK]
Common Mistakes:
MISTAKES- Confusing append with merge
- Thinking delete+insert updates rows
- Mixing full refresh with incremental
Master "Incremental Models" in dbt
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore dbt Quizzes