Amazon Athena export compressed query (table)

Question

When I do a query like:

SELECT * FROM mytable

the output is saved in an Amazon S3 bucket as a plain CSV.

Is there an option to save the csv in a compressed format (gzip)?

Answer 1

There is no output compression option (currently) available.

The only options are:

• Selecting the output bucket
• Encrypting query results