You can use either of the following two export methods:
Connect an external workbench and use that to export your data. This is available through the Connect menu.
Use UNLOAD queries to export the query result to the desired S3 bucket. For example:
UNLOAD ('select-statement') TO 's3://object-path/name-prefix' authorization
More information is available at: http://docs.aws.amazon.com/redshift/latest/dg/r_UNLOAD.html
Please sign in to leave a comment.