Which of the following is the correct YAML syntax to add a dbt-utils uniqueness test on columns user_id and order_id?

easy📝 Syntax Q3 of 15

dbt - Advanced Testing

Which of the following is the correct YAML syntax to add a dbt-utils uniqueness test on columns user_id and order_id?

Atests: - dbt_utils.unique: columns: ['user_id', 'order_id']

Btests: - dbt_utils.unique_combination_of_columns: combination_of_columns: ['user_id', 'order_id']

Ctests: - dbt_utils.unique_combination_of_columns: columns: ['user_id', 'order_id']

Dtests: - dbt_utils.unique_combination_of_columns: combination_of_columns: user_id, order_id

Step-by-Step Solution

Solution:

Step 1: Recall correct parameter name
The correct parameter for this test is combination_of_columns with a list of column names.
Step 2: Check YAML list syntax
The list must be in square brackets with quotes around each column name, as in tests: - dbt_utils.unique_combination_of_columns: combination_of_columns: ['user_id', 'order_id'].
Final Answer:
tests: - dbt_utils.unique_combination_of_columns: combination_of_columns: ['user_id', 'order_id'] -> Option B
Quick Check:
Correct YAML key and list format = tests: - dbt_utils.unique_combination_of_columns: combination_of_columns: ['user_id', 'order_id'] [OK]

Quick Trick: Use combination_of_columns with list syntax in YAML [OK]

Common Mistakes:

MISTAKES

Master "Advanced Testing" 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