Performing custom ‘not empty’ tests

dbt is shipped with essential schema tests which I covered in one of my previous posts on CORE DWH test suite. There are plenty of additional tests and handy macros shipped with the dbt-utils package, including equal_rowcount, expression_is_true, recency, at_least_one, etc.

But still if you need something special you can easily add it yourself. For me this is signalling if one of my source tables is empty.

https://kzzzr.github.io/Performing-custom-not-empty-tests/