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
UnloadOptions Property File
field. Enter the options in uppercase and delimit the options by using a The Unload command has the following options and default values:
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
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.