Skip to main content
Feedback

RVR-ATH-302

Issue summary

The error code RVR-ATH-302 with the description "Error trying to connect to get buckets." indicates an issue with the permissions or configurations related to accessing Amazon S3 buckets when setting up a connection with Amazon Athena in Data Integration.

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 Data Integration connection has 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:

    • Ensure to configure the S3 buckets intended for Athena query results and datasets with the necessary permissions. The IAM policy attached to your AWS credentials must provide access to these buckets.

  3. Configure the IAM role:

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

  4. Allowlist Data Integration IP addresses:

    • Ensure that Data Integration IP addresses are allowlisted in your AWS settings if an IP-based firewall restricts your connection.

  5. Test the connection:

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

External references

For more information, refer to the Data Integration Documentation on Amazon Athena, and AWS IAM Policy Reference topics.

note

If the issue persists or you need further assistance, open a support case with Data Integration Support. In the console sidebar, select Help > Contact Us and follow the instructions.

On this Page