search

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

BigQuery OMOP: device exposure code uses ALL-CAPS #203

Closed mgkahn closed 3 years ago

mgkahn commented 3 years ago

Bigquery is case sensitive in table names (but not column names, go figure).

New extract code for device_exposure table is written in ALL-CAPS in FROM and JOIN clauses (lines 289-290) OMOP standard (which Colorado follows) is lower-case table names.

Please change DEVICE_EXPOSURE --> device_exposure and N3C_COHORT --> nc3_cohort in lines 289-290

image
mgkahn commented 3 years ago

Ugh -- so sorry to re-open. I missed one instance of ALL-CAPS DEVICE_EXPOSURE, which causes bigquery to bomb. Line 519 while creating DATA_COUNTS.CSV

image