search

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

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

Closed jeancochrane closed 2 months ago

jeancochrane commented 4 months ago

From discussion on #323:

Land actually can be exempt on a non-exempt parcel e.g. you can have a EX land code on a 211 pardat parcel. However, the reverse is not true (can't have an EX pardat parcel and a 200 land class).

Add one or more tests to confirm that parcels that are exempt in pardat are also exempt in all of the other tables that have class columns.

jeancochrane commented 2 months ago

Once https://github.com/ccao-data/data-architecture/pull/390 lands, we can use it to test the following models: