Amazon Redshift Connectors

Back Next

Amazon Redshift V2 targets

You can use an Amazon Redshift V2 object as a target in a

mapping

task. You can also create an Amazon Redshift V2 target based on the input source.

When you configure the advanced target properties, configure properties specific to Amazon Redshift V2. You can encrypt data, update statistical metadata of the database tables to improve the efficiency of queries, load data into Amazon Redshift from flat files in an Amazon S3 bucket, and use vacuum tables to recover disk space and sort rows in tables.

If the distribution key column in a target table contains null values and you configure a task with an upsert operation for the same target table, the task might create duplicate rows. To avoid creating duplicate rows, you must perform one of the following tasks:

Replace the null value with a non-null value when you load data.

Do not configure the column as a distribution key if you expect null values in the distribution key column.

Remove the distribution key column from the target table temporarily when you load data. You can use the Pre-SQL and Post-SQL properties to remove and then add the distribution key column in the target table.

Amazon Redshift sources and targets

Amazon Redshift staging directory for Amazon Redshift V2 targets

Data encryption in Amazon Redshift V2 targets

Recovery and restart processing

Preserve record order on Write

Octal values as DELIMITER and QUOTE

Success and error files

Download Guide