Boomi · Data Integration: Amazon Athena
RVR-ATH-100: error trying to connect to Athena
Short answer
RVR-ATH-100 means Data Integration could not connect to Amazon Athena, from misconfigured connection settings or missing permissions. Verify the region, workgroup and credentials, and the IAM permissions.
VerifiedLast verified
01Error text
Error trying to connect to Athena. Error Code: RVR-ATH-10002Likely causes
- Misconfigured connection settings.
- Insufficient permissions.
03How to fix it
- Verify the region, workgroup and credentials (AWS keys or an IAM role).
- Give the IAM user or role permissions such as
glue:GetDatabases,glue:GetTablesands3:ListAllMyBuckets. - Allowlist Data Integration IP addresses in AWS security groups if that applies.
- Use Test Connection on the connection in Data Integration.
04Official documentation
→Related errors
- RVR-ATH-200: error in query execution result (Athena)RVR-ATH-200 means a query Data Integration ran against Athena failed, from configuration, bucket permissions or the query itself. Check the S3 and Athena permissions and the SQL.
- RVR-S3-100: S3 loading errorRVR-S3-100 is an S3 loading error, usually a permission or configuration problem with the bucket used as a source or target. Check the IAM permissions and the bucket name and path.
Test every fix in a non-production environment before you apply it to production. See how entries are verified.
More for Boomi work:Open Boomi jobsBoomi rates and salaries