PowerExchange for Amazon Redshift User Guide

10.4.0
- 10.5.6
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5
- 10.4.1

Back Next

Unload Command Options

The Unload command options extract data from Amazon Redshift and load data to staging files on Amazon S3 in a particular format. PowerExchange for Amazon Redshift only supports DELIMITER, PARALLEL, AWS_IAM_ROLE, and ADDQUOTES unload command options.

To add options to the Unload command, use the

Unload Options

option. The ESCAPE option is set by default. You can set the following options:

DELIMITER: A single ASCII character to separate fields in the input file. Default is \036, the octal representation of the non-printable character and the record separator.; You can use characters such as pipe (|), tilde (~), or a tab (\t). The delimiter you specify should not be a part of the data. If the delimiter is a part of data, use ESCAPE to read the delimiter character as a regular character.
PARALLEL: The Unload command writes data in parallel to multiple files, according to the number of slices in the cluster. Default is On.; If you turn the Parallel option off, the Unload command writes data serially. The maximum size of a data file is 6.5 GB. Do not use
PARALLEL OFF
if you run a mapping on the Blaze engine.
NULL: You can use NULL Unload command option to replace the null values in an Amazon Redshift source table with the string that you specify using the NULL Unload command option.; Enter the value of the NULL Unload command option in the following format:
NULL=text
. Do not add spaces when you enter the string value. For more information about the NULL Unload command, see the AWS documentation.; Applicable when you run a mapping in the native environment.
AWS_IAM_ROLE: Specify the Amazon Redshift Role Resource Name (ARN) to run the session on Data Integration Service installed on an Amazon EC2 system in the following format:
AWS_IAM_ROLE=arn:aws:iam::<account ID>:role/<role-name>; For example:
arn:aws:iam::123123456789:role/redshift_read
ADDQUOTES: The UNLOAD command can read data values that contain the delimiter. The Unload command adds quotation marks to each data field. If double quote (") is a part of data, use ESCAPE to read the double quote as a regular character.

Rename Saved Search

Table of Contents

PowerExchange for Amazon Redshift User Guide

PowerExchange for Amazon Redshift User Guide

Unload Command Options

Unload Command Options