[Solved] Given this snippet in a schema.yml file:tests: - expect_column_values_to_be_between: min_value: 10 max_value: 100What does this test check for the column? | dbt

dbt - Advanced Testing

Given this snippet in a schema.yml file:

tests:
  - expect_column_values_to_be_between:
      min_value: 10
      max_value: 100

What does this test check for the column?

AValues are between 10 and 100 inclusive

BValues are unique

CValues are not null

DAll values are exactly 10 or 100

Step-by-Step Solution

Solution:

Step 1: Understand the test name
The test expect_column_values_to_be_between checks if values fall within a range.
Step 2: Interpret parameters
Parameters min_value: 10 and max_value: 100 mean values must be between 10 and 100, including these limits.
Final Answer:
Values are between 10 and 100 inclusive -> Option A
Quick Check:
Between test checks range limits [OK]

Quick Trick: Between test checks inclusive range by default [OK]

Common Mistakes:

MISTAKES

Master "Advanced Testing" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

Given this snippet in a schema.yml file: