|Talend Version (Required)||All versions|
|tRedshiftBulkExec can't handle data with double-quotes.|
|Product (Required)||Data Integration|
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|