Once you’re in the AWS Athena console, you’ll find the necessary configuration details:
Access Key and Secret Access Key:
Click on your username at the top right corner of the AWS Management Console.
Choose “Security Credentials” from the dropdown menu.
In the “Access keys” section, you can create or view your access keys.
If you haven’t created an access key pair before, click on “Create access key” to generate a new one. Make sure to copy the Access Key ID and Secret Access Key as they are shown only once.
Region:
The AWS region can be selected from the top right corner of the AWS Management Console. Choose the region where your AWS Athena resources are located or where you want to perform queries.
Workgroup:
In the AWS Athena console, navigate to the “Workgroups” section in the left sidebar.
Here, you can view the existing workgroups or create a new one if needed. Note down the name of the workgroup you want to use.
Catalog and Database:
Go to the “Data Source” section in the in the left sidebar.
Select the catalog that contains the databases and tables you want to query. Note down the name of the catalog and database.
Output Location:
In the AWS Athena console, click on “Settings”.
Under “Query result location,” you can see the default output location for query results. You can also set a custom output location if needed. Note down the output location URL.