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?

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

Aucune réponse

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions