tRedshiftBulkExec throws "Invalid quote formatting for CSV" error

Talend Version (Required)       All versions

Summary

tRedshiftBulkExec can't handle data with double-quotes.
Additional Versions  
Product (Required) Data Integration
Component (Required) Components
Problem Description

Assume a CSV data file has a column value with data containing double-quotes, such as "test \"".

The tRedshiftBulkExec advanced parameter Enclosed by is set to Double quote.

However, tRedshiftBulkExec throws an Invalid quote formatting for CSV error.

Problem root cause

AWS documentation suggests adding an additional quote character; for details, see Data Format Parameters in the Amazon Redshift Database Developer Guide.

Solution or Workaround You need to replace "test \"" with "test """ so that tRedshiftBulkExec can handle it.
JIRA ticket number  
Version history
Revision #:
2 of 2
Last update:
‎10-30-2017 04:14 PM
Updated by:
 
Labels (2)
Contributors