[GH-ISSUE #100] work.cost_domain_id_swap does not exist #58

Closed
opened 2026-03-23 20:28:46 +00:00 by mirror · 1 comment
Owner

Originally created by @loreV-edenceHealth on GitHub (Sep 17, 2024).
Original GitHub issue: https://github.com/RADar-AZDelta/Rabbit-in-a-Blender/issues/100

when processing the logic for cost table, src/riab/etl/sql_server/templates/etl/{omop_table}_merge.sql.jinja tries to do a left join.
LEFT OUTER JOIN [{{work_database_catalog}}].[{{work_database_schema}}].[{{column}}_swap] swap_fk{{ns.fk_counter}} on swap_fk{{ns.fk_counter}}.x = t.[{{column}}]
I can not find a place in the code where work.cost_domain_id_swap would be created so am wondering if this is a bug.

Originally created by @loreV-edenceHealth on GitHub (Sep 17, 2024). Original GitHub issue: https://github.com/RADar-AZDelta/Rabbit-in-a-Blender/issues/100 when processing the logic for cost table, src/riab/etl/sql_server/templates/etl/{omop_table}_merge.sql.jinja tries to do a left join. LEFT OUTER JOIN [{{work_database_catalog}}].[{{work_database_schema}}].[{{column}}_swap] swap_fk{{ns.fk_counter}} on swap_fk{{ns.fk_counter}}.x = t.[{{column}}] I can not find a place in the code where work.cost_domain_id_swap would be created so am wondering if this is a bug.
Author
Owner

@pjlammertyn commented on GitHub (Sep 18, 2024):

We havent used the cost table yet.
I will try with a dummy query to get it working.

<!-- gh-comment-id:2358028592 --> @pjlammertyn commented on GitHub (Sep 18, 2024): We havent used the cost table yet. I will try with a dummy query to get it working.
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
RADar-AZDelta/archived-Rabbit-in-a-Blender#58
No description provided.