Boomi · Data Integration: Amazon Athena

RVR-ATH-200: error in query execution result (Athena)

Short answer

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.

VerifiedLast verified

01Error text

Boomi error
Error in query execution result. Error Code: RVR-ATH-200

02Likely causes

  • Configuration issues, permission errors on the data buckets, or the queries themselves.

03How to fix it

  1. Confirm the AWS credentials can access the S3 buckets and Athena.
  2. Grant permissions such as s3:ListBucket, s3:GetObject and athena:StartQueryExecution.
  3. Check the SQL and that the S3 data format supports the operation.
  4. Check the workgroup configuration.

04Official documentation

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

The iPaaS Brief

Subscribe to The iPaaS Brief.

The iPaaS newsletter for the people who run integrations. From iPaaS Group.

Free. You finish on theipaasbrief.com and confirm by email.