How to download encrypted Athena query results in readable format

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.

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.