omop-learn icon indicating copy to clipboard operation
omop-learn copied to clipboard

Not all databases support COPY TO syntax

Open ablack3 opened this issue 4 years ago • 1 comments

Redshift does not seem to support queries of the form

copy (select * from schema.table)
to sdtout
with csv HEADER

which are used in the FeatureGenerator

It seems like cross-database COPY TO syntax might be problematic. Is the intention for this code to run on several database platforms or just postgres?

ablack3 avatar Apr 14 '21 15:04 ablack3

Hi there,

Yes - at the moment, this code is just meant to run on postgres. Some members of our team are working on making the code compatible with different databases, but the ETA is unknown on that. If you have any suggestions on how best to do it we would really appreciate your input!

Best, Justin

justinlimkz avatar Apr 15 '21 14:04 justinlimkz