https://pulumi.com logo
#aws
Title
# aws
c

curved-account-29261

01/17/2024, 6:47 AM
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:
Copy code
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),
    },