Good day, I am trying to setup a Glue Connection using AWS Secret Manager to store the credentials. I am able to create the

secret

and

secretversion

and then retrieve the credentials (

username

and

password

) and then injecting them in the connection definition but it is not what I am looking for. I end up with a connection using

Credential Type

Username and password. I want to use AWS Secrets Manager. The documentation doesn't provide much explanation on how to achieve it. my Typescript code look like:

const redshiftConnection = new aws.glue.Connection("redshiftConnection", {
    connectionProperties: {
        JDBC_CONNECTION_URL: interpolate`jdbc:redshift://${redshiftWorkgroup.workgroupName}.${awsAccountId}.${region}.<http://redshift-serverless.amazonaws.com:${redshiftWorkgroup.port}/${dbname}|redshift-serverless.amazonaws.com:${redshiftWorkgroup.port}/${dbname}>`,
        USERNAME: redshiftSecret.name.apply((name) => name as string),
        PASSWORD: redshiftSecretVersion.secretString.apply((secret) => secret as string),
    },