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

Mutliactive Config in Stage with single key and hashkey is not working #241

Closed MatheHostel closed 2 months ago

MatheHostel commented 2 months ago

Description

multiactive_config: multi_active_key:

some_field main_hashkey_column:
hk_customer_h

Creates error on different places. column "hk_customer_h" does not exist in ldts_rsrc_data

syntax error at or near "'hk_customer_h'" in context ", main_hashkey_generation.['hk_customer_h'", at line 177, column 32

syntax error at or near "'hk_customer_h'" in context "ldts_rsrc_data GROUP BY ['hk_customer_h'", at line 139, column 15

syntax error at or near "FROM" in context ", "some_field2", "some_field3",

FROM", at line 101, column 3

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?

Config as described above

[ ] 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)

MatheHostel commented 2 months ago

We found our misunderstanding. The "main_hashkey_column" should only contain one column where "multi_active_key" should be named "multi_active_keys" which makes it more easier to understand that with trailing "s" is for a list and without an "s" is for only one value.