PowerExchange for Amazon Redshift User Guide for PowerCenter

Back Next

Copy Command

You can use the Copy command to append data in a table. The Copy command uses a secure connection to load data from source to Amazon Redshift.

You can specify the Copy command options directly in the

CopyOptions Property File

field. Enter the options in uppercase and delimit the options by using a

space.

The Copy command has the following options and default values:

DELIMITER=\036 ACCEPTINVCHARS=? QUOTE=\037 COMPUPDATE=OFF AWS_IAM_ROLE=

arn:aws:iam::<account ID>:role/<role-name>

You can also create a property file.

The property file contains the Copy command options. Include the property file path in the

CopyOptions Property File

field. For example:

C:\Temp\Redshift\copyoptions.txt

In the property file, delimit the options by using a new line. For example:

DELIMITER=\036

ACCEPTINVCHARS=?

QUOTE=\037

COMPUPDATE=OFF

AWS_IAM_ROLE=

arn:aws:iam::<account ID>:role/<role-name>

It is recommended to use octal representation of non-printable characters as DELIMITER and QUOTE.