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
preguntada hace un año449 visualizaciones
2 Respuestas
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
respondido hace un año
  • 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
respondido hace un año

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas