To debug an error, consult first the documentation.
This is a must have to preview model excerpts and test out blocks of a complex logic causing a test to fail or wrong data in the output.
Repo here
We are able to write test failures and warnings directly into our datawarehouse. It helps in identifying records responisble for the anomaly.
Add to dbt_project.yml
Optional schema parameter will store audit tables in target.schema_audit schema
tests:
+store_failures: true
+schema: 'audit'For more check out the official documentation