search

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

Speed up import of vocabularies on SQL Server #55

Closed pjlammertyn closed 4 months ago

pjlammertyn commented 4 months ago

The OHDSI DDL creates a clustered index on the _id columns.

image

The generated vocabularies CSV's bij Athena are NOT sorted on the _id column:

image

pjlammertyn commented 4 months ago

solved in merge request https://github.com/RADar-AZDelta/Rabbit-in-a-Blender/pull/56