QuestionQ5

Verified

You wrote the following test against your fct_orders model to verify that a parent model applied status filters properly:

\{\{  
config(  
enabled=true, severity='error'  
)  
\}\}  
select *  
from \{\{ ref('fct_orders') \}\}  
where status_code = 13  

Which statement about this test is correct?

Explanation

A singular dbt data test returns records that violate its assertion. Here, the query returns rows with status_code = 13, so those rows cause the test to fail under the default failure threshold. The configured severity reports the failure as an error. (docs.getdbt.com)

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!