- Newest
- Most votes
- Most comments
Please see below answers to your questions:
-
Since unload uses SELECT statement to get data, the data type conversions are like what happen in normal SELECT output shown on screen. Customer can perform type casting in SELECT statement used with UNLOAD for conversions needed.
-
As per Redshift documentation[1] UNLOAD does not support Amazon S3 server-side encryption with a customer-supplied key (SSE-C).
-
Manifest file created by UNLOAD is a JSON file, so JSON format is used and JSON notations are used for beginning and end of records in it.
-
Refer Redshift usage notes[1] has some of failure conditions in UNLOAD.
Apart from above mentioned points you are recommended to check the UNLOAD documentation[3] for more details.
[1] http://docs.aws.amazon.com/redshift/latest/dg/r_UNLOAD.html [2] http://docs.aws.amazon.com/redshift/latest/dg/r_UNLOAD.html#unload-usage-notes [3] http://docs.aws.amazon.com/redshift/latest/dg/r_UNLOAD_command_examples.html
Relevant content
- asked a year ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 6 months ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago