[Solved] You want to create a generic test that checks if a numeric column's values are within a custom range using... Which YAML snippet correctly calls this test for column age with range 18 to 65? | dbt

dbt - Advanced Testing

You want to create a generic test that checks if a numeric column's values are within a custom range using parameters min_value and max_value. Which YAML snippet correctly calls this test for column age with range 18 to 65?

Atests: - within_range('age', 18, 65)

Btests: - within_range: column: 'age' min: 18 max: 65

Ctests: - within_range: column_name: 'age' min_value: 18 max_value: 65

Dtests: - within_range: column_name: age min_value: '18' max_value: '65'

Step-by-Step Solution

Solution:

Step 1: Use correct parameter names
The test expects parameters named 'column_name', 'min_value', and 'max_value'.
Step 2: Use correct YAML syntax and types
tests: - within_range: column_name: 'age' min_value: 18 max_value: 65 uses correct parameter names and numeric values without quotes for numbers.
Step 3: Check other options
Function call syntax is invalid in YAML; incorrect parameter names like 'column', 'min', 'max'; unquoted column name and quoted numbers may cause type issues.
Final Answer:
tests: - within_range: column_name: 'age' min_value: 18 max_value: 65 -> Option C
Quick Check:
Correct params + types = tests: - within_range: column_name: 'age' min_value: 18 max_value: 65 [OK]

Quick Trick: Match parameter names and use correct YAML types [OK]

Common Mistakes:

MISTAKES

Using wrong parameter keys like 'column' or 'min'
Passing numbers as strings
Using function call syntax in YAML

Master "Advanced Testing" in dbt

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

More dbt Quizzes

Which YAML snippet correctly calls this test for column age with range 18 to 65?

Step 1: Use correct parameter names

Step 2: Use correct YAML syntax and types

Step 3: Check other options

Final Answer:

Quick Check:

Want More Practice?