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