search

OHDSI / CohortGenerator

Cohort Generation for the OMOP Common Data Model
https://ohdsi.github.io/CohortGenerator/
11 stars 10 forks source link

`#nc_set` temp table not dropped on DataBricks #188

Closed anthonysena closed 5 days ago

anthonysena commented 3 weeks ago

See below:

image

#nc_set should be dropped after generation.

anthonysena commented 3 weeks 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