search

Missouri-BMI / OMOP_ON_P_CDM

Apache License 2.0
0 stars 0 forks source link

Run Achilles on GPC OMOP data #82

Open vasanthi014 opened 2 months ago

shossain-mizzou commented 2 months ago

@vasanthi014 , select drug_exposure_id from ATLAS_GPC_DEV.CDM.DRUG_EXPOSURE error: Numeric value '81ecbbbfb1ace3f7' is not recognized

shossain-mizzou commented 2 months ago

select VISIT_END_DATETIME from ATLAS_GPC_DEV.CDM.VISIT_OCCURRENCE; --Timestamp '2020-03-24 51780' is not recognized

shossain-mizzou commented 2 months ago

select PROCEDURE_OCCURRENCE_ID from ATLAS_GPC_DEV.CDM.PROCEDURE_OCCURRENCE; --Numeric value '5BB0D6C1-4A03-EF11-B11F-005056A5B8E9' is not recognized

shossain-mizzou commented 2 months ago

select CONDITION_OCCURRENCE_ID from ATLAS_GPC_DEV.CDM.CONDITION_OCCURRENCE; --Numeric value 'DX:149949671:13:1612089' is not recognized

shossain-mizzou commented 2 months ago

@vasanthi014 , can we somehow validate OMOP cdm scripts by running atleast 'select *' on corresponding tables before running Achilles?

vasanthi014 commented 2 months ago

@vasanthi014 , can we somehow validate OMOP cdm scripts by running atleast 'select *' on corresponding tables before running Achilles?

yes. I will create a process in snowflake to run these queries before running Achilles.