[BUG] Ghost Record Macro not working when multiple src_pk columns

[ambullo]

We activated ghost records in our config but run into some issues.

We have multiple columns for the src_pk of our satellites. However, the macro for the ghost records does not accept multiple columns at this point. Therefore it will just ignore them and we run into a compilation error when we want to run the model.

The macro needs to be adjusted to accept multiple src_pk columns and handle them correctly. Point in the code where the issue occurs:

automate-dv/macros/supporting/ghost_records/create_ghost_record.sql

Line 34 in f0cf634

{%- if ((col_name | lower) == (src_pk | lower)) or ((col_name | lower) == (src_hashdiff | lower)) -%}

AB#5345

[DVAlexHiggs]

Hi! Thank you for bringing this to our attention - it was an oversight on our part. We'll make sure a fix is including in our upcoming release. Thanks!