ScalefreeCOM / datavault4dbt

Scalefree's dbt package for a Data Vault 2.0 implementation congruent to the original Data Vault 2.0 definition by Dan Linstedt including the Staging Area, DV2.0 main entities, PITs and Snapshot Tables.

https://www.scalefree.com/

Apache License 2.0

143 stars 27 forks source link

business key is not listed in cte "source_new_union" when there is only one source per hub #238

Closed MatheHostel closed 2 months ago

MatheHostel commented 3 months ago

Description

source_newunion is not listing the business key bk which is used in records_to_insert when only one source is used in a hub

Fixes #(issue)

Type of change

Please delete options that are not relevant.

[x] Bug fix (non-breaking change which fixes an issue)
[ ] New feature (non-breaking change which adds functionality)
[ ] Breaking change (fix or feature that would cause existing functionality to not work as expected)
[ ] This change requires a documentation update

How Has This Been Tested?

Please describe the tests that you ran to verify your changes. Provide instructions so we can reproduce.

[ ] Tests you ran

Test Configuration:

datavault4dbt-Version:
dbt-Version: cloud/core, version number
dbt-adapter-Version:

Checklist:

[x] I have performed a self-review of my code
[ ] I have commented my code, particularly in hard-to-understand areas
[ ] I have made corresponding changes to the documentation or included information that needs updates (e.g. in the Wiki)