
## 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))