search

transferwise / pipelinewise-target-redshift

Singer.io Target for Amazon Redshift - PipelineWise compatible
https://transferwise.github.io/pipelinewise/
Other
12 stars 65 forks source link

Configurable COPY options #21

Closed koszti closed 5 years ago

koszti commented 5 years ago

Addressing https://github.com/transferwise/pipelinewise-target-redshift/issues/8 . copy_option in config.json override the defaults COPY options.

Default COPY option slightly changed to deal with long text fields:

DELIMITER ',' REMOVEQUOTES ESCAPE
EMPTYASNULL BLANKSASNULL TRIMBLANKS TRUNCATECOLUMNS
TIMEFORMAT 'auto'
COMPUPDATE OFF STATUPDATE OFF