dbt - Advanced Testing
What will happen if you run a dbt test with
store_failures = true but no rows fail the test?What will happen if you run a dbt test with store_failures = true but no rows fail the test?
medium📝 Predict Output Q5 of 15
Step-by-Step Solution
Solution:
Step 1: Understand behavior when no failures occur
dbt still creates the failure table to keep schema consistent.Step 2: Confirm content of failure table
Since no rows failed, the table will be empty but exist.Final Answer:
The failure table will be created but empty. -> Option AQuick Check:
No failures means empty failure table exists [OK]
Quick Trick: Empty failure table still created if no failures [OK]
Common Mistakes:
MISTAKES- Assuming no table is created
- Expecting an error on no failures
- Thinking table contains all rows
Master "Advanced Testing" in dbt
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore dbt Quizzes