[Solved] You wrote this test in your schema.yml:tests: - expect_column_values_to_be_in_set: column: status values_set: ['active', 'inactive']But the test always errors out. What is the likely problem? | dbt

dbt - Advanced Testing

You wrote this test in your schema.yml:

tests:
  - expect_column_values_to_be_in_set:
      column: status
      values_set: ['active', 'inactive']

But the test always errors out. What is the likely problem?

AThe test name is misspelled

BThe list should be a string, not a list

CThe key should be <code>value_set</code> not <code>values_set</code>

DThe column name is missing

Step-by-Step Solution

Solution:

Step 1: Check parameter names for the test
The correct parameter is value_set, not values_set.
Step 2: Identify cause of error
Using wrong key causes test to error because it doesn't recognize the parameter.
Final Answer:
The key should be value_set not values_set -> Option C
Quick Check:
Parameter names must be exact [OK]

Quick Trick: Check exact parameter names in docs [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: