Metadata
- Author: Leo Godin
- Full Title:: Transform, Test, Publish
- Category:: 🗞️Articles
- Document Tags:: dbt,
- URL:: https://www.blef.fr/r/b1e1e4e8?m=6d6aa78e-ae1e-424c-b3c3-accaaae0b850
- Finished date:: 2023-09-26
Highlights
Add a view between downstream consumers and the model being tested. The steps are as follows.
- Create a view between the tested model and downstream consumers.
- Give the view a where clause based on a date or timestamp.
- Whenever the view runs, update the date or timestamp.
- If tests fail, then the dependent view will not run, thus retaining the last known good date or timestamp. (View Highlight)