ccao-data / data-architecture

Codebase for CCAO data infrastructure construction and management
https://ccao-data.github.io/data-architecture/
5 stars 3 forks source link

Add `expression_is_false` dbt test macro #463

Closed wrridgeway closed 1 month ago

wrridgeway commented 1 month ago

Our current expression_is_true dbt tests can lead to some weird backwards engineering trying to figure out how to invert logic given how it employs NOT before the WHERE clause it tests. Having an alternative to avoid these situations would be helpful.