RVR-ATH-302

1. Issue Summary

• Error Code: RVR-ATH-302
• Data Connector: Amazon Athena
• Error Description: Error trying to connect to get buckets.

This error generally indicates an issue with the permissions or configurations related to accessing Amazon S3 buckets when setting up a connection with Amazon Athena in Rivery. The Athena connection requires permissions to access the S3 buckets that store query results and datasets.

2. Action Steps

To resolve the error, follow these steps:

1. Check AWS Credentials:

   • Ensure that the AWS Access Key and Secret Key provided in the Rivery connection have the necessary permissions to access S3 buckets. The IAM user or role should include permissions for actions such as s3:ListBucket, s3:GetBucketLocation, s3:GetBucketCORS, and s3:ListAllMyBuckets.

2. Verify S3 Bucket Permissions:

   • Verify that the S3 buckets intended for Athena query results and datasets are properly configured with the necessary permissions. The IAM policy attached to your AWS credentials must allow access to these buckets.

3. Configure the IAM Role:

   • If you are using IAM Role authentication, ensure that the CloudFormation Stack is correctly set up and that the proper role is assumed. The role should have the required permissions to access the S3 buckets.

4. Whitelist Rivery IP Addresses:

   • Ensure that Rivery's IP addresses are whitelisted in your AWS settings if your connection is restricted by an IP-based firewall.

5. Test the Connection:

   • Use the "Test Connection" feature in the Rivery console to verify if the connection is active. If the test fails, revisit the above steps.

3. External References

• Rivery Documentation on Amazon Athena
• AWS IAM Policy Reference

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