dbt - Advanced Testing
You want to write a custom test in dbt to check that the 'price' column is always greater than zero. Which approach correctly applies this test?
You want to write a custom test in dbt to check that the 'price' column is always greater than zero. Which approach correctly applies this test?
hard📝 Application Q8 of 15
Step-by-Step Solution
Solution:
Step 1: Understand how to create custom tests in dbt
Custom tests require SQL files with logic and referencing them in schema.yml.Step 2: Evaluate options
Create a SQL file in tests/ folder with a query filtering price <= 0 and reference it in schema.yml correctly describes creating a SQL test and linking it. Others are incorrect or outside dbt.Final Answer:
Create a SQL file in tests/ folder with a query filtering price <= 0 and reference it in schema.yml -> Option CQuick Check:
Custom tests need SQL files and schema.yml reference [OK]
Quick Trick: Custom tests require SQL files and schema.yml links [OK]
Common Mistakes:
MISTAKES- Assuming custom tests work without SQL files
- Using built-in tests for unsupported checks
- Running external scripts instead of dbt tests
Master "Advanced Testing" in dbt
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore dbt Quizzes