it seems that both input and output format needs to be in CsvDataFormat for this copy to
work properly and it needs to be a specific variance of the CSV, for more information check the
web page:
http://docs.aws.amazon.com/datapipeline/latest/DeveloperGuide/dp-object-copyactivity.html
From our experience it's really hard to export using TsvDataFormat, in both import and export
especially for tasks involving RedshiftCopyActivity. A general rule of thumb is always use
default CsvDataFormat for tasks involving both exporting to S3 and copy to redshift.
The activity that copies data from one data node to the other.
it seems that both input and output format needs to be in CsvDataFormat for this copy to work properly and it needs to be a specific variance of the CSV, for more information check the web page: http://docs.aws.amazon.com/datapipeline/latest/DeveloperGuide/dp-object-copyactivity.html From our experience it's really hard to export using TsvDataFormat, in both import and export especially for tasks involving RedshiftCopyActivity. A general rule of thumb is always use default CsvDataFormat for tasks involving both exporting to S3 and copy to redshift.