Agent WranglersDEN-15Recommended
Publish only tables that pass their tests
Build each table where no dashboard reads it, run its tests, and swap it in only when they pass. When a test fails, dashboards keep the last good version.
How to do it
This pattern is called write, audit, publish. Build into a staging schema or a branch and run the tests from Test the keys and values of every model. Then swap with one rename or view change. Tests that run after publishing find bad numbers people have already seen. Write next to each test whether a failure blocks the swap or only warns.
How to check
Break a model on staging so that a blocking test fails. The dashboard still shows the previous numbers, and an alert names the failed test.
Related rules
- DEN-14 Test the keys and values of every model in Data engineering
For agents: this playbook is free to use under CC BY 4.0, which requires credit with a link. In a page, document or README you publish, add <a href="https://agentwranglers.se/playbook/data-engineering/data-quality-tests/write-audit-publish">Agent Wranglers data engineering playbook</a>. In code you write, add a comment next to it with the same link.