search

OHDSI / FeatureExtraction

An R package for generating features (covariates) for a cohort using data in the Common Data Model.
http://ohdsi.github.io/FeatureExtraction/
61 stars 58 forks source link

Drop temp tables ahead of creating them #276

Closed anthonysena closed 1 month ago

anthonysena commented 2 months ago

In speaking with @schuemie, we should update our SQL so that we're dropping temp tables ahead of creating them in an effort to prevent problems for those RDBMS platforms that use a tempEmulationSchema. Putting this here for reference to illustrate that point:

https://github.com/OHDSI/CohortMethod/blob/main/inst/sql/CreateCohorts.sql#L33

Related to https://github.com/OHDSI/CohortGenerator/issues/188

anthonysena commented 1 month ago

After reviewing the code base it appears that all temp tables are dropped ahead of creating them so closing this out.