[Solved] What is the output of this dbt-utils test configuration?tests: - dbt_utils.relationship: column: customer_id to: ref('customers') field: idAssuming some customer_id values do not exist in customers.... | dbt

dbt - Advanced Testing

What is the output of this dbt-utils test configuration?

tests:
  - dbt_utils.relationship:
      column: customer_id
      to: ref('customers')
      field: id

Assuming some customer_id values do not exist in customers.id, what happens?

AThe test fails due to foreign key violations.

BThe test only checks data types, so it passes.

CThe test throws a compilation error.

DThe test passes because relationship tests ignore missing references.

Step-by-Step Solution

Solution:

Step 1: Understand relationship test purpose
This test checks that all values in customer_id exist in the referenced customers.id column.
Step 2: Analyze missing references effect
If some customer_id values are missing in customers.id, the test fails due to foreign key violations.
Final Answer:
The test fails due to foreign key violations. -> Option A
Quick Check:
Missing references = test fails [OK]

Quick Trick: Relationship test fails if foreign keys are missing [OK]

Common Mistakes:

MISTAKES

Master "Advanced Testing" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

What is the output of this dbt-utils test configuration?