There are a few PINs in the iasWorld backend used for testing new features, calculations, etc. We want these in the raw ias data but probably don't need to expose them via our primary views. Write a quick regular expression/filter to catch and exclude the mentioned test PIN, then add a dbt test/regex to test any further malformed PINs and add it to the QC workbooks.
See https://github.com/ccao-data/public/issues/25.
There are a few PINs in the iasWorld backend used for testing new features, calculations, etc. We want these in the raw ias data but probably don't need to expose them via our primary views. Write a quick regular expression/filter to catch and exclude the mentioned test PIN, then add a dbt test/regex to test any further malformed PINs and add it to the QC workbooks.