[Solved] This test configuration causes dbt to fail:tests: - dbt_utils.accepted_values: column: status values: active, inactiveWhat is the error? | dbt

dbt - Advanced Testing

This test configuration causes dbt to fail:

tests:
  - dbt_utils.accepted_values:
      column: status
      values: active, inactive

What is the error?

AThe test name is misspelled.

BThe values list is missing brackets and quotes.

CThe column name should be a list, not a string.

DThe values parameter should be called accepted_values.

Step-by-Step Solution

Solution:

Step 1: Check YAML list syntax for values
The values must be a list with brackets and quotes around each value.
Step 2: Identify the error
Here, values are given as a comma-separated string without brackets or quotes, causing failure.
Final Answer:
The values list is missing brackets and quotes. -> Option B
Quick Check:
Lists need brackets and quotes in YAML [OK]

Quick Trick: Always use brackets and quotes for lists in YAML [OK]

Common Mistakes:

MISTAKES

Master "Advanced Testing" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

This test configuration causes dbt to fail: