Anyone know if we can pass a password at time of E...
# troubleshootingd
devon_seitz
04/17/2023, 7:39 PMAnyone know if we can pass a password at time of ELT command? meltano elt tap-postgres --password HERE target-snowflake
v
visch
04/17/2023, 7:41 PMYes, check out https://docs.meltano.com/guide/configuration#configuring-settings . Environment variables can be set 🙂
d
devon_seitz
04/17/2023, 7:42 PMahh got it so we could do something like
devon_seitz
04/17/2023, 7:43 PM Copy code
EXPORT TAP_POSTGRES__PASSWORD=HERE && meltano elt tap-postgres target-snowflakedevon_seitz
04/17/2023, 7:43 PMty!
devon_seitz
04/17/2023, 7:50 PMok so i asked this question and you were perfect in answering it but is there a better way to put PW in a docker image that can then be called by airflows DockerOperator?
devon_seitz
04/17/2023, 7:51 PMprob best to call the
environment={key: value}devon_seitz
04/17/2023, 7:51 PMpiping the value from maybe an airflow variable
v
visch
04/17/2023, 7:52 PMI'm no airflow pro, but generally yes orchestrators pass secrets via environment variables to the process that's consuming the secrets
d
devon_seitz
04/17/2023, 7:52 PMcoolio!
devon_seitz
04/17/2023, 7:52 PMty again