Adding AWS Athena Connection
Adding a New Database:
In the 'Manage Warehouses' section:
- Click on 'Add New', select type as 'AWS Athena'
- A form will be presented to you. Fill out the necessary details for the connection.
- AWS Region Name:
- Enter the AWS region where your Athena database is located (e.g.,
us-east-1).
- Enter the AWS region where your Athena database is located (e.g.,
- S3 Staging Directory:
- Enter the S3 bucket path where Athena will store query results (e.g.,
s3://your-bucket/path/).
- Enter the S3 bucket path where Athena will store query results (e.g.,
- AWS Access Key Id:
- Enter your AWS access key ID.
- AWS Secret:
- Enter your AWS secret access key.
- Data Source Name (Optional):
- Enter a custom data source name if you're using a named data source. Leave empty for the primary data source.
- AWS Region Name:
- After entering the details, click on Submit.
Note: Ensure your AWS credentials have appropriate permissions to access Athena and the S3 bucket specified in the staging directory.