omop-learn
omop-learn copied to clipboard
Not all databases support COPY TO syntax
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?
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