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?