You can use an Amazon Redshift V2 object as a target in a data loader task.
When you create a data loader task to write data to Amazon Redshift, specify the Amazon Redshift V2 target properties.
The following table describes the Amazon Redshift V2 target properties:
Property
Description
Connection
Name of the target connection.
Path
The Amazon Redshift schema name where you want to create the target table.
S3 Bucket Name
The Amazon S3 bucket name for writing files to an Amazon Redshift target.
You can also specify the bucket name with the folder path. The Amazon S3 bucket must be in the same region as the Amazon Redshift cluster.
Target Name Prefix
Optional prefix for the target table names. If you enter a prefix, the target table names are the same as the source table names plus the prefix.
For example, if you enter pfx1_ as the prefix, the data from source object src1 will be written to target table pfx1_src1.
Update mode for Amazon Redshift V2 targets
When you write data into an Amazon Redshift V2 target, the data loader task either performs an upsert or an insert operation based on how the primary key and watermark fields are configured in the source object.
When you define a primary key field for the source object, the data loader task performs an upsert operation.
When you don't define a primary key fields or watermark fields for the source, the data loader task performs an insert operation.