awslabs/aws-athena-query-federation

[BUG] character “!” is not allowed in the secret name with connector mysql

tahub05 opened this issue · 0 comments

Describe the bug
When using the Amazon Athena MySQL connector, if "!" is included in the secret name of Secrets Manager used when connecting to the database, the connection will fail.

To Reproduce
Steps to reproduce the behavior:

  1. Integrate Secrets Manager with Amazon RDS, and manage authentication information with Secrets Manager. At this time, the name of the secret is “rds! cluster-xxxxxxxxxx”.
  2. Deploy a Lambda function using the Athena MySQL connector.
  3. Create an Athena data source and use that Lambda function to connect to the data source.
  4. cannot connect to the database and an error occurs.

Expected behavior
The connection to the database succeeds even if “!” is included in the secret name

Screenshots / Exceptions / Errors
WrongArgumentException: Malformed database URL, failed to parse the connection string near '${rds!cluster-xxxxxxxxxx}'.

Connector Details (please complete the following information):

  • Version: 2024.25.1
  • Name: mysql