search

OHDSI / ClinicalCharacteristics

[under development] table shell approach to OMOP characterization
Apache License 2.0
0 stars 0 forks source link

If execution fails, breaks table may not get dropped #13

Closed katy-sadowski closed 2 months ago

katy-sadowski commented 5 months ago

Should add DROP IF EXISTS prior to the SELECT INTO queries in Step 1: https://github.com/OHDSI/ClinicalCharacteristics/blob/6ac4deaf485a9cfb1f5bd3e52f01f47ed4dc2e20/R/conversion.R#L312-L322

mdlavallee92 commented 5 months ago

ok added tempEmulationSchema in SqlRender::translate. This should drop it treating all tables as temp even in snowflake. Will close with PR to main