How to download encrypted Athena query results in readable format


I want to download query results in Athena to csv in a readable format. The problem is that results are encrypted. What is the best practice to do? Or is it a wrong approach? I just need to share a few tables with colleagues who don't use Athena.

asked 4 months ago27 views
2 Answers

You can download results files from the console from the Results pane when using the console or from the query History. For more information, see Downloading query results files using the Athena console..

If you dont need your query results to be encrypted in the S3 bucket, you can turn off encrytion too and provide the user access to the S3 bucket they files will be named named as QueryID.csv NOTE: AWS customers rarely choose this option, when they are sure about their end users with access to the bucket.

profile picture
answered 4 months ago
  • Thanks. I need encryption. I don't want to turn it off completely.


As my goal is to keep query results encryption but at the same time to be able to download results, I do not want to disable encryption. I found that to download query output my user/role needs to be granted access to the KMS key that is used for query results encryption. This should allow downloading files and they will no longer be encrypted on the local disk.

answered 4 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions