tuva
tuva copied to clipboard
PK, Medical Claim Basic Dates & Medical Claim Patient_ID data quality checks
Describe your changes
Added 3 data quality tests to the core models. The PK model checks the uniqueness of primary keys across core data models. The Basic Dates & Patient_ID checks look at the Medical Claim core data model.
How has this been tested?
I ran this code in Snowflake using the CMS_SYNTHETIC._TUVA_CLAIMS data tables.
Reviewer focus
Please review if these checks pass the data quality needs, and if they pass the SQL standards that Tuva has.
Checklist before requesting a review
- [x] I have added at least one Github label to this PR (bug, enhancement, breaking change,...)
- [ ] My code follows style guidelines
- [x] (New models) YAML files are categorized by sub folder and models listed in alphabetical order
- [x] (New models) I have added a config to each new model to enable it for claims and/or clinical data
- [x] (New models) I have added the variable
tuva_last_run
to the final output - [ ] (Optional) I have recorded a Loom to explain this PR
Package release checklist
- [ ] I have updated dbt docs
- [ ] I have updated the version number in the
dbt_project.yml