How can I export a table?

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 Icon 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