dbt - Incremental Models
Which of the following is the correct way to specify a composite unique_key in a dbt model's merge config?
merge:
unique_key: ?Which of the following is the correct way to specify a composite unique_key in a dbt model's merge config?
easy📝 Syntax Q12 of 15
Step-by-Step Solution
Solution:
Step 1: Recall syntax for composite unique_key
dbt expects a list of column names for composite keys, written as ['col1', 'col2'].Step 2: Match syntax options
['id', 'date'] uses a list syntax with square brackets and quotes, which is correct.Final Answer:
['id', 'date'] -> Option AQuick Check:
Composite unique_key = list of columns [OK]
Quick Trick: Use list syntax ['col1', 'col2'] for composite keys [OK]
Common Mistakes:
MISTAKES- Using a string with commas instead of a list
- Using curly braces which is invalid syntax
- Trying to add columns with + operator
Master "Incremental Models" in dbt
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore dbt Quizzes