Transform Test Publish

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.

1. Create a view between the tested model and downstream consumers.
2. Give the view a where clause based on a date or timestamp.
3. Whenever the view runs, update the date or timestamp.
4. If tests fail, then the dependent view will not run, thus retaining the last known good date or timestamp. (View Highlight)