Define a dbt test to ensure that exempt pardat parcels are also exempt in all related tables

ccao-data / data-architecture

Codebase for CCAO data infrastructure construction and management

https://ccao-data.github.io/data-architecture/

6 stars 4 forks source link

Define a dbt test to ensure that exempt pardat parcels are also exempt in all related tables #395

Closed Damonamajor closed 5 months ago

Damonamajor commented 5 months ago

This produces three tests, one for asmt_all, oby, and land, each of which tests that all values in pardat which are exempt, are exempt in the tested tables. It fails in two occasions, land (14 failures) and oby (3), while passing in asmt_all.