Confirm the following files were correctly updated automatically:
[x] CHANGELOG
[x] README
[x] apple_store.yml
[x] docs.md
[x] joins
note when joining the seeded country_codes, source_relation would not be included
[ ] ~window functions (partition by)~
[x] 'source_relation' column added in transform models
[x] tests
Manual updates:
[x] Add source_relation to downstream models if necessary
[x] Finish any incomplete/incorrect joins/partitions
[x] Update tests to include source_relation in unique-combination-of-cols if necessary
May need to remove some uniqueness tests in favor of the combo test
Validation:
Consistency: When not using unioning, tests in the folder tests/consistency/row_counts pass
It is is expected that the consistency tests will not pass when unioning
Integrity: I was able to write 1 integrity test for app_store_territory_source_type_report since there wasn't much aggregation from the source, but the others were too complex to write a meaningful test.
Issue:
Confirm the following files were correctly updated automatically:
country_codes,source_relationwould not be includedManual updates:
source_relationto downstream models if necessarysource_relationin unique-combination-of-cols if necessaryValidation:
Consistency: When not using unioning, tests in the folder
tests/consistency/row_countspassIntegrity: I was able to write 1 integrity test for
app_store_territory_source_type_reportsince there wasn't much aggregation from the source, but the others were too complex to write a meaningful test.Spot check with seed data for unioning:
Also: