Note: event_id template joins on 'None_swap' work table

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

Note: event_id template joins on 'None_swap' work table #76

Closed lbertelo01 closed 2 months ago

lbertelo01 commented 2 months ago

Events are however correctly defined: https://github.com/RADar-AZDelta/Rabbit-in-a-Blender/blob/main/src/riab/etl/cdm_5.4_events.json

During the execution of this template, a connection error arises.

pjlammertyn commented 2 months ago

Is this not the result of a hickup in the internet connection to GCP? @lbertelo01

pjlammertyn commented 2 months ago

This comes because of filling in the wrong field with the referring table! Column note_event_field_concept_id should contain the table name and not column note_event_id!