To connect to an Amazon Athena data source, you will need the following information:
- AWS Access Key and AWS Secret Key
See Amazon’s Creating an IAM User in Your AWS Account. Ensure user has access to Athena.
- Database Name
- S3 Staging Directory
The IAM user that created the API access keys will need to have S3 access to both the S3 bucket where the data is read from and the S3 bucket where the query results are stored. The
AmazonAthenaFullAccess policy only gives access to the query result S3 bucket. You will also need to add a policy to the user so it has access to the data.