By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Issue accessing RDS from Athena using Federated Query and AthenaJdbcConnector connector

0

I'm currently facing an issue while accessing a RDS (MySQL) in another AWS account, using a shared VPC through AWS Athena Federated Query. I have already configured everything, including VPC, Subnets. Additionally, I have added the necessary IAM Role and permissions to access the necessary feature.

However, I encountered the following error when selecting the Data Source in Athena: "GENERIC_USER_ERROR: Encountered an exception[java.lang.RuntimeException] from your LambdaFunction[arn:aws:lambda:us-east-1:990612511553:function:mysql] executed in context[retrieving meta-data] with message[1045: java.sql.SQLException: Access denied for user 'athena'@'10.0.1.143' (using password: YES)]"

Can anyone assist me in resolving this issue?

  • vtjean
    a year ago

    How are you connecting to the database since the error is in java? Is it through another AWS Service?

Topics
AnalyticsDatabaseSecurity, Identity, & ComplianceNetworking & Content Delivery
Tags
Amazon AthenaDatabaseIAM PoliciesShared VPCMySQL
Language
English
pedrowurzel
asked a year ago138 views
No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content