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?

No hay respuestas

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas