Release Notes > Summer 2016 - June > Amazon Redshift Connector
  

Amazon Redshift Connector

Amazon Redshift Connector Fixed Limitations

Review the Release Notes of previous releases for information about previous fixed limitations.
The following table describes fixed limitations:
CR
Description
CON-4043
When you create a mapping configuration task with Amazon Redshift connection, the following tool tip is displayed with the CopyOptions Property File in the target properties and UnloadOptions Property File in the source properties:
Pass either options directly in Text Area or the absolute path of the property file which contains the options to be appended to the COPY or UNLOAD command. Currently, the options supported are:
DELIMITER
PARALLEL
ESCAPE
Workaround: Ignore the tool tip. Provide the absolute path of the property file in the text box.
CON-2680
You need not change the delimiter character when the delimiter used is part of the data. Amazon Redshift connection uses ADDQUOTES by default.
CON-2426
You can successfully run multiple tasks in parallel when you write to the same Amazon S3 bucket.
CON-2343
When you join two table in the query in mapping or Mapping Configuration task with Amazon Redshift connection and the query contains columns that have same names from both tables, the task fails.

Amazon Redshift Connector Known Limitations

The following table describes known limitations:
CR
Description
CON-3158
The Data Synchronization and Mapping Configuration tasks that use a filter or query in which the where clause for which the value provided has a single quote fails.
CON-1925
For Amazon Redshift connection, COMPUPDATE OFF is not honored when the target table is already compressed, even if you enable the Truncate Target Table Before Data Load option. The pg_table_def table shows that the data is compressed.
Workaround: Create a fresh target table and use COMPUPDATE OFF to disable automatic compression.
CON-454
If you use Amazon Redshift source objects with more than two levels of relationships in a Data Synchronization task, the Refresh Fields option does not display the metadata for those objects. You can save and run the task, but the task fails at run time.
Workaround: Create a new Data Synchronization task that contain objects with two or less than two levels of relationships, or use the mapping configuration task.