You can specify the Unload command options directly in the

UnloadOptions Property File

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

space.

The Unload command has the following options and default values:

DELIMITER=\036 ESCAPE=OFF PARALLEL=ON AWS_IAM_ROLE=

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

You can also create a property file.

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

UnloadOptions Property File

field. For example:

C:\Temp\Redshift\unloadoptions.txt

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

DELIMITER=\036

ESCAPE=OFF

PARALLEL=ON

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.

If you run the Unload command as a pre-SQL or post-SQL command, specify the

ALLOWOVERWRITE

option to overwrite the existing objects.