search

EHDEN / ETL-UK-Biobank

ETL UK-Biobank
https://ehden.github.io/ETL-UK-Biobank/
12 stars 4 forks source link

Add views of vocab tables to cdm schema #282

Closed MaximMoinat closed 3 years ago

MaximMoinat commented 3 years ago

For some OHDSI packages (e.g. CdmInspection) the vocabularies should be in the same schema as the cdm data. Currently these are in a separate 'vocab' schema.

As a hack, we can add views from the omop to vocab schema: https://github.com/thehyve/ohdsi-omop-pioneer/blob/master/other/vocab_view.sql

MaximMoinat commented 3 years ago

For our internal development environment, having a separate vocabulary schema saves disk space. We don't need to populate a separate vocabulary for each ETL we do.