RVR-ATH-205

1. Issue Summary

   • The error code RVR-ATH-205 encountered when connecting to Amazon Athena with the error message "Error trying to connect to get buckets" typically indicates a problem with accessing the bucket list necessary for the connection. This issue can be caused by incorrect permissions or configurations in the AWS environment set up for Rivery's Athena connection. Specifically, the IAM role or user associated with Rivery might not have sufficient permissions to list S3 buckets, which is critical for Athena connections.

2. Action Steps:

   • Verify IAM Permissions: Ensure that the IAM role or user used by Rivery has the s3:ListAllMyBuckets permission. This can be checked and adjusted in the AWS IAM console. Here's an example of how your policy might look:

     {
       "Version": "2012-10-17",
       "Statement": [
         {
           "Sid": "RiveryHeadBucketsAndGetLists",
           "Effect": "Allow",
           "Action": "s3:ListAllMyBuckets",
           "Resource": "*"
         }
       ]
     }
     

   • Check AWS Credentials: Confirm that the AWS access key and secret key provided in the Rivery Athena connection configuration are valid and correspond to the correct AWS account.
   • Test Network Connectivity: Ensure that there are no network issues blocking the connection to AWS from Rivery.
   • Correct Region Settings: Ensure that the AWS region specified in Rivery matches the region in which you have your resources configured.

3. External References:

   • For further configuration guidelines and examples, refer to Rivery's official documentation on Connecting to Amazon Athena.
   • General AWS IAM policy guidance can be found on AWS's official documentation.

If the issue persists or you need further assistance, please open a ticket with Rivery support.