Use projects group password in python script

I have a Blob Storage connection string stored in Azure Key Vault, and I’ve added the Key Vault to the Secret Manager in Matillion under Project Group Passwords. I then created a password entry in Matillion from the configured Secret Manager.

Now, I want to use this password directly in the Python Script component within a job.

How can I access the secret or password value inside the Python Script component?

Hi @RemigiousMikevin.James

Thanks for your post, I was just looking into this for you and can confirm you cannot allow Python Access to the Matillion Secrets Vault. If you are using the AWS / Azure Secrets Manager, an option would be to write a Python code to connect directly to AWS / Azure to retrieve the secret you need.

Another option would be to store the password directly in a variable outside of the Matillion Secrets Manager and access it via Environment Variables.

Here is a supporting document for AWS Secrets Manager :slight_smile:

Kidn regards, Joe