Build of stg_ga4__page_conversions model fails when the value set for conversion_events is a special character that does not correspond to a column name.
Soluton:
Define a new optional variable conversion_event_column_renamers whose key matches conversion_events and assign the column name renamed at query generation time.
Checklist
[x] I have verified that these changes work locally
[x] I have updated the README.md (if applicable)
[x] I have added tests & descriptions to my models (and macros if applicable)
[x] I have run dbt test and python -m pytest . to validate existing tests
Description & motivation
Current Issue:
Build of
stg_ga4__page_conversionsmodel fails when the value set forconversion_eventsis a special character that does not correspond to a column name.Soluton:
Define a new optional variable
conversion_event_column_renamerswhose key matchesconversion_eventsand assign the column name renamed at query generation time.Checklist
dbt testandpython -m pytest .to validate existing tests