QuestionQ55

Verified

Consider this query:

select *  
from \{\{ ref('stg_orders') \}\}  
where amount_usd < 0  

You want to turn it into a generic test across multiple models.

Which set of two standard arguments should replace \{\{ ref('stg_orders') \}\} and amount_usd? Choose 1 option.

Explanation

A dbt generic data test uses model for the tested relation and column_name for the tested column. Templating these arguments allows the negative-value check to be reused across models and columns. (docs.getdbt.com)

Learn more

Community Discussion

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