Feature: Union schema compatibility - Githubissues

fivetran / dbt_microsoft_ads

Fivetran data transformations for Microsoft (Bing) Ads built using dbt.

https://fivetran.github.io/dbt_microsoft_ads/

Apache License 2.0

3 stars 6 forks source link

Feature: Union schema compatibility #28

Closed fivetran-catfritz closed 11 months ago

fivetran-catfritz commented 1 year ago

Issue: #27

Confirm the following files were correctly updated automatically:

[x] CHANGELOG
[x] README
[x] stg_microsoft_ads.yml, src_microsoft_ads.yml, microsoft_ads.yml (depending if source or transform)
[x] docs.md
[x] joins
[ ] ~window functions (partition by)~
[x] 'source_relation' column added in staging and 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:

[x] dbt run locally passes
[x] dbt test locally passes