[Solved] You wrote this test in your schema.yml:tests: - dbt_utils.unique_combination_of_columns: combination_of_columns: ['id', 'date'But dbt throws a syntax error. What is the likely cause? | dbt

dbt - Advanced Testing

You wrote this test in your schema.yml:

tests:
  - dbt_utils.unique_combination_of_columns:
      combination_of_columns: ['id', 'date'

But dbt throws a syntax error. What is the likely cause?

AMissing closing bracket for the list of columns.

BIncorrect test name; it should be <code>unique_combination_columns</code>.

CThe test requires a <code>column</code> parameter, not <code>combination_of_columns</code>.

DYAML indentation is incorrect.

Step-by-Step Solution

Solution:

Step 1: Check YAML syntax
The snippet shows an opening bracket for the list but no closing bracket, causing syntax error.
Step 2: Verify test name and parameters
The test name and parameter are correct; the error is due to incomplete list syntax.
Final Answer:
Missing closing bracket for the list of columns. -> Option A
Quick Check:
Unclosed list brackets cause YAML syntax errors [OK]

Quick Trick: Always close YAML lists with brackets [OK]

Common Mistakes:

MISTAKES

Master "Advanced Testing" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

You wrote this test in your schema.yml: