RVR-ATH-100

Issue summary

The error code RVR-ATH-100 with the description "Error trying to connect to Athena." indicates a problem with establishing a connection to Amazon Athena from the Data Integration platform. This error suggests misconfigured connection settings or insufficient permissions.

Action steps

To resolve the error, follow these steps:

1. Check connection settings:

   • Ensure that the connection settings in Data Integration is correctly configured by verifying the region, workgroup, and credentials (AWS Access Key and Secret Access Key).
   • Review the connection procedure to Athena, using either AWS Keys or an IAM Role. Make sure that you have followed the necessary steps to set these up correctly.

2. Verify permissions:

   • Confirm that the IAM user or role used for Data Integration has the necessary permissions to access Athena. This includes permissions like glue:GetDatabases, glue:GetTables, and s3:ListAllMyBuckets.
   • If you're using IAM Role Automatic or Manual, ensure that the IAM policy 'Data Integration-Athena-Policy' is attached and includes the required actions.

3. Network and access:

   • Make sure the IPs used by Data Integration is allowlisted in your AWS security groups and firewall settings, if applicable.

4. Test connection:

   • Use the Test Connection feature in Data Integration to verify the connection to Athena. This step will help confirm whether the settings and permissions are correctly applied.

External references

• For further details on setting up connections in Data Integration, refer to the Data Integration Amazon Athena connection topic.
• For creating a work group and permissions in Athena, refer to the AWS Athena documentation.

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.