OHDSI Home | Forums | Wiki | Github

Bigquery schemas for CDM 5

(Javier Gracia-Tabuenca) #1


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 ??

(Thanos Vidakis) #2

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

(Javier Gracia-Tabuenca) #3

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.

(Gregory Klebanov) #4

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

(Michael Kahn) #5

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)