bigquery/OMOP: sex/hispanic/race data type confusion

National-COVID-Cohort-Collaborative / Phenotype_Data_Acquisition

The repository for code and documentation produced by the N3C Phenotype and Data Acquisition workstream

60 stars 35 forks source link

Closed mgkahn closed 3 years ago

mgkahn commented 3 years ago

Three tables define sex, hispanic, race as STRING.

SQL is inserting INT64 concept_id into STRING sex field (same with hispanic, race):

In bigquery, errors w/o explicit cast.

empfff commented 3 years ago

Fixed this in the GBQ script, thanks.