OHDSI Home | Forums | Wiki | Github

Bigquery schemas for CDM 5

Hello,

We would like to load the CDM v5 into BigQuery, however on the github repo (https://github.com/OHDSI/CommonDataModel/tree/master/BigQuery) these schemas are only available for CDM v6.

Since v5 is the more commonly used, has any one writen the BigQuery for CDMv5 ??

Not sure if this is the correct answer as I am new here but you might try to check code from the tag v5.3.1

Hope this is helpful

Ok, thanks a lot @thanos_vidakis .
I had selected 5.3.2 and they did not appear there. I thougth they did not existed before that point.

@Javier I do not believe there is 5.3.2 release (yet). The latest is 5.3.1 - please pick this one

The is the GBQ DDL for 5.3.1 that we use at the University of Colorado. I did not attempt to do a diff with what Gregory posted.

OMOP V5.3.1 BigQuery DDL.docx (23.6 KB)

t