You can specify the Copy command options directly in the

Copy Options

field. Enter the options in uppercase and use a semicolon to separate the options. For example,

DELIMITER=\036;ACCEPTINVCHARS=#;QUOTE=\037;COMPUPDATE=ON;AWS_IAM_ROLE=arn:aws:iam::<account ID>:role/<role-name>

Even if you specify the delimiter as a semicolon, you must use a semicolon to separate the options. For example,

DELIMITER=;;ACCEPTINVCHARS=#;QUOTE=\037;COMPUPDATE=ON;AWS_IAM_ROLE=arn:aws:iam::<account ID>:role/<role-name>

You can create a property file to specify the Copy command options. Enter the options in uppercase in separate lines. You must place the property file in any location in the machine on which the Data Integration Service runs. For example:

DELIMITER = \036
ACCEPTINVCHARS = #
QUOTE = \037
COMPUPDATE = ON
AWS_IAM_ROLE=arn:aws:iam::<account ID>:role/<role-name>

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

Copy Options

field. For example:

C:\Temp\Redshift\copyoptions.txt

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