[Solved] A dbt test is written as:tests: - unique - not_null - accepted_values: values: ["active", "inactive"] What is wrong with this test if the column contains values like "pending"? | dbt

dbt - Governance and Collaboration

A dbt test is written as:

tests:
  - unique
  - not_null
  - accepted_values:
      values: ["active", "inactive"]

What is wrong with this test if the column contains values like "pending"?

AThe test will fail because unique is not allowed with accepted_values

BThe test will pass because all values are strings

CThe test will fail because "pending" is not an accepted value

DThe test will pass because not_null ignores values

Step-by-Step Solution

Solution:

Step 1: Understand accepted_values test
This test only allows specified values in the column.
Step 2: Check column values against allowed list
"pending" is not in ["active", "inactive"], so test fails.
Final Answer:
The test will fail because "pending" is not an accepted value -> Option C
Quick Check:
Value outside accepted list = Test fail [OK]

Quick Trick: Accepted values test rejects unexpected entries [OK]

Common Mistakes:

MISTAKES

Master "Governance and Collaboration" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

A dbt test is written as: