I have got a key and secrets key for an external S3 bucket full of .gz files. I need to analyze this data using Athena. Is there an option to connect Athena to the S3 bucket using a key and secret key? if so, how to do it?

I know how to connect S3 when I get a console connection but not when I've only a key and secret key.

CodePudding user response：

It is more comlicated than answering with a single answer.

As it was mentioned already, you cannot have access to the console with only the secret key. You can use those credential for programatic access for example from your CLI.

What you might want to try is to use the AWS CLI tool. https://docs.aws.amazon.com/cli/latest/reference/athena/start-query-execution.html

aws athena start-query-execution <query>