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?

Nessuna risposta

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande