[Solved] If a dbt test is defined as:tests: - accepted_values: values: ['active', 'inactive']What will happen if a row has the value 'pending' in the tested column? | dbt

dbt - Advanced Testing

If a dbt test is defined as:

tests:
  - accepted_values:
      values: ['active', 'inactive']

What will happen if a row has the value 'pending' in the tested column?

AThe test will throw a runtime error

BThe test will pass because 'pending' is treated as null

CThe test will ignore the row with 'pending'

DThe test will fail because 'pending' is not an accepted value

Step-by-Step Solution

Solution:

Step 1: Understand accepted_values test
This test checks if column values are in the specified list.
Step 2: Analyze the effect of an unexpected value
Any value not in the list causes the test to fail.
Final Answer:
The test will fail because 'pending' is not an accepted value -> Option D
Quick Check:
Accepted values test fails on unexpected values [OK]

Quick Trick: Accepted_values test fails on values outside the list [OK]

Common Mistakes:

MISTAKES

Master "Advanced Testing" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

If a dbt test is defined as: