You can specify the Unload command options directly in the

Unload Options

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

DELIMITER=\036;PARALLEL=ON;NULL=text;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=;;PARALLEL=ON;NULL=text;AWS_IAM_ROLE=arn:aws:iam::<account ID>:role/<role-name>

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

DELIMITER = \036
PARALLEL = ON
NULL=text
AWS_IAM_ROLE=arn:aws:iam::<account ID>:role/<role-name>

Include the property file path in the

Unload Options

field. For example:

C:\Temp\Redshift\unloadoptions.txt

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