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