fivetran / dbt_apple_store

Fivetran's Apple App Store source dbt package
https://fivetran.github.io/dbt_apple_store/
Apache License 2.0
0 stars 2 forks source link

Bug/add alt country names #11

Closed fivetran-jamie closed 1 year ago

fivetran-jamie commented 1 year ago

PR Overview

This PR will address the following Issue/Feature: https://github.com/fivetran/dbt_apple_store_source/issues/8

This PR will result in the following new package version:

v0.3.0 because the source package has a breaking change (and users of the transform package will also need to re seed the country code data)

Please detail what change(s) this PR introduces and any additional information that should be known during the review of this PR: most of the changes happened in the source PR, but here:

PR Checklist

Basic Validation

Please acknowledge that you have successfully performed the following commands locally:

Before marking this PR as "ready for review" the following have been applied:

Detailed Validation

Please acknowledge that the following validation checks have been performed prior to marking this PR as "ready for review":

validation for this is largely here in the transform package, where i

  1. pointed to the working branch of the source package
  2. added a couple of new countries to one of the territory seed files (specifically Kosovo and two different versions of spelling for the Ivory Coast)
  3. reseeded and reran everything upstream of the territory report
  4. confirmed that the new countries had non-null data from the country code file (so the joins worked) image
  5. confirmed that different spellings of a country will indeed split out into distinct rows (but can be aggregated by their identical country codes)

Standard Updates

Please acknowledge that your PR contains the following standard updates:

dbt Docs

Please acknowledge that after the above were all completed the below were applied to your branch:

If you had to summarize this PR in an emoji, which would it be?