How to download encrypted Athena query results in readable format

0

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.

MikeW
質問済み 1年前449ビュー
2回答
1

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 pictureAWS
回答済み 1年前
  • Thanks. I need encryption. I don't want to turn it off completely.

0

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.

MikeW
回答済み 1年前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ