[Solved] Given this YAML test snippet:tests: - dbt_utils.accepted_values: column: status values: ['active', 'inactive']What will happen if the status column contains the value 'pending'? | dbt

dbt - Advanced Testing

Given this YAML test snippet:

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

What will happen if the status column contains the value 'pending'?

AThe test will pass because 'pending' is treated as NULL.

BThe test will ignore 'pending' values and pass.

CThe test will fail because 'pending' is not in the accepted values list.

DThe test will throw a syntax error.

Step-by-Step Solution

Solution:

Step 1: Understand accepted_values test behavior
This test checks that all values in the column are within the specified list.
Step 2: Check if 'pending' is in the list
'pending' is not in ['active', 'inactive'], so the test will fail.
Final Answer:
The test will fail because 'pending' is not in the accepted values list. -> Option C
Quick Check:
Value outside accepted list = test fails [OK]

Quick Trick: Values outside accepted list cause test failure [OK]

Common Mistakes:

MISTAKES

Master "Advanced Testing" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

Given this YAML test snippet: