Amazon recommends to use the following PostgreSQL JDBC driver to connect to Redshift: http://docs.aws.amazon.com/redshift/latest/mgmt/connecting-using-workbench.html

-- http://jdbc.postgresql.org/download/postgresql-8.4-703.jdbc4.jar

System table reference: http://docs.aws.amazon.com/redshift/latest/dg/cm_chap_system-tables.html

COPY command options via JDBC:

-- http://stackoverflow.com/questions/6958965/how-to-copy-a-data-from-file-to-postgresql-using-jdbc

-- http://www.postgresql.org/docs/8.1/static/sql-copy.html

-- this is different from our import b/c the file is directly passed to the server. COPY syntax doesn't seem to allow for arbitrary user mapping of columns. Requires further investigation. COPY does seem to support STDIN so maybe it is possible to dynamically generate COPY statements as opposed to INSERT statements.

Logged a separate issue for this: #11151

initial support complete.  Will begin on Copy Command research & development.  issue 11151

Hello

Please provide steps to verify this issue

Verified in ADS v15.0.0-dev-287