[Solved] You wrote this test in your schema.yml:tests: - expect_column_values_to_be_unique_or_nullsBut dbt throws an error when running tests. What is the likely cause? | dbt

dbt - Advanced Testing

You wrote this test in your schema.yml:

tests:
  - expect_column_values_to_be_unique_or_nulls

But dbt throws an error when running tests. What is the likely cause?

AThe test name is incorrect; it should be expect_column_values_to_be_unique_or_nulls

BThe test name is incorrect; it should be expect_column_values_to_be_unique_or_null

CThe test requires parameters min_value and max_value

DThe test cannot be used in schema.yml files

Step-by-Step Solution

Solution:

Step 1: Check test name spelling
The correct test name is expect_column_values_to_be_unique_or_null without the trailing 's'.
Step 2: Understand test usage
This test does not require parameters and is valid in schema.yml files.
Final Answer:
The test name is incorrect; it should be expect_column_values_to_be_unique_or_null -> Option B
Quick Check:
Exact test names matter for dbt-expectations [OK]

Quick Trick: Check exact test function names for typos [OK]

Common Mistakes:

MISTAKES

Master "Advanced Testing" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

You wrote this test in your schema.yml: