Not all databases support COPY TO syntax

clinicalml / omop-learn

Python package for machine learning for healthcare using a OMOP common data model

MIT License

104 stars 26 forks source link

Not all databases support COPY TO syntax #7

Open ablack3 opened 3 years ago

ablack3 commented 3 years ago

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?

justinlimkz commented 3 years ago

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