![rw-book-cover](https://miro.medium.com/v2/resize:fit:792/1*37CeZu2wCz4aiheXuQNoZA.png) ## Metadata - Author: [[leo-godin|Leo Godin]] - Full Title:: Transform, Test, Publish - Category:: #🗞️Articles - Document Tags:: [[DBT|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](https://read.readwise.io/read/01hb829z1wsmc4az7wj51gx9dr))