Table of Contents

Search

  1. Preface
  2. Part 1: Introduction to Amazon Redshift connectors
  3. Part 2: Data Integration with Amazon Redshift V2 Connector
  4. Part 3: Data Integration with Amazon Redshift Connector

Amazon Redshift Connectors

Amazon Redshift Connectors

Unload command

Unload command

You can use the Unload command to extract data from Amazon Redshift and create staging files on Amazon S3. The Unload command uses a secure connection to load data into one or more files on Amazon S3.
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;ESCAPE = OFF;NULL=text;PARALLEL = ON;AWS_IAM_ROLE=arn;aws;iam;;<account ID>;role/<role-name>
The NULL Unload command option does not apply to
elastic mappings
.
It is recommended to use octal representation of non-printable characters as DELIMITER.
If you run the Unload command as a pre-SQL or post-SQL command, specify the
ALLOWOVERWRITE
option to overwrite the existing objects.
By default, the UNLOAD property field is empty.