Dbt, Data Quality, Data Testing, Data Analytics, Data Governance.
that we want to test against: select customer_id from (select * from stg_customers where country not in ('US', 'Canada')) dbt_subquery where customer_id is null; Once again, the test will fail if the query returns any record given the set conditions. Although it’s possible to configure a warn test