RADar-AZDelta / Rabbit-in-a-Blender

An ETL pipeline to transform your EMP data to OMOP.
https://radar-azdelta.github.io/Rabbit-in-a-Blender/
GNU General Public License v3.0
11 stars 3 forks source link

work.cost_domain_id_swap does not exist #100

Closed lore-edencehealth closed 2 months ago

lore-edencehealth commented 2 months ago

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.

pjlammertyn commented 2 months ago

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