[Solved] Given this YAML snippet for a dbt test:columns: - name: user_id tests: - unique - not_nullWhat will dbt test check for the user_id column? | dbt

dbt - Advanced Testing

Given this YAML snippet for a dbt test:

columns:
  - name: user_id
    tests:
      - unique
      - not_null

What will dbt test check for the user_id column?

AIt checks that user_id values are duplicated and null

BIt checks that user_id values are unique and not null

CIt only checks if user_id is unique

DIt only checks if user_id is not null

Step-by-Step Solution

Solution:

Step 1: Read the tests listed for user_id
The YAML shows two tests: 'unique' and 'not_null' for the user_id column.
Step 2: Understand what each test does
'unique' ensures no duplicate values; 'not_null' ensures no missing values.
Final Answer:
It checks that user_id values are unique and not null -> Option B
Quick Check:
unique + not_null = no duplicates, no nulls [OK]

Quick Trick: Multiple tests run together on the same column [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 snippet for a dbt test: