Describe the issue

I am trying to create glue connection using cdk. The connection is to the aurora database inside vpc. I have gotten connection setup and working via the AWS console and currently trying to automate it with cdk. I am getting stuck in the part where have to specify connection properties and its not well documented on at properties need to be passed.

Here is what I got working and deployed to aws

However, I want to replace the username and password with the secret from AWS Secret Manager. When I setup the RDS cluster, I am using Credentials.fromGeneratedSecret which seem to create secret in secret manager. I looked around for documentation on how to specify the secret manager secret arn in cdk but could not figure out how.

This is possible via the AWS console. Please see the screenshot below.

Links

https://docs.aws.amazon.com/cdk/api/v2/docs/@aws-cdk_aws-glue-alpha.Connection.html#propertiesspan-classapi-icon-api-icon-experimental-titlethis-api-element-is-experimental-it-may-change-without-noticespan