We have a large number of tables to connect to and are using environmental variables as much as possible to reduce the amount of work needed for config changes, however for the password to a database if we use an environmental variable the value is in plain text.
Would it be possible to add a new type to the environmental variables that doesn't show the value ie password field type?
8 Community Answers
Ed Thompson —
We hope to introduce a password manager which will allow you to manage passwords across a project, and then reference the password by name in the components. At that point, using a variable for the password’s name will be fine, and its value will be retrieved when the job runs.
Because of this plan, it is unlikely we will introduce a password-style variable type.
I’ll post again once we know when it will be available.
For Bash and Python scripts that’s the case, yes: you will need to embed them in the script, either as a string literal or using a Matillion Environment Variable. It’s better to use an environment variable because then it can automatically have different values in dev/test/production etc.
I’ll update this thread once additional options have become available.