[Solved] You wrote this test in your YAML file:columns: - name: order_id tests: unique not_nullBut when you run dbt test, it fails with a syntax error. What is the likely cause? | dbt

dbt - Advanced Testing

You wrote this test in your YAML file:

columns:
  - name: order_id
    tests:
      unique
      not_null

But when you run dbt test, it fails with a syntax error. What is the likely cause?

AUsing 'tests' instead of 'test' key

BIncorrect indentation of 'name' key

CMissing quotes around test names

DMissing dash (-) before 'unique' and 'not_null' tests

Step-by-Step Solution

Solution:

Step 1: Check YAML list syntax for tests
Each test under 'tests' must be a list item starting with a dash (-).
Step 2: Identify missing dashes
The snippet shows 'unique' and 'not_null' without dashes, causing YAML syntax error.
Final Answer:
Missing dash (-) before 'unique' and 'not_null' tests -> Option D
Quick Check:
YAML lists need dash (-) before each item [OK]

Quick Trick: Always put dash (-) before each test in YAML list [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 YAML file: