GitHub user AchimGaedkeLynker created a discussion: How to update a connection 
password (secret rotation)?

I failed to google this question and find an answer specific to 3.x - as the 
direct access to the ORM is prevented (used to do this in airflow 2.x)

I try to create an airflow task, which:

* Retrieves the most recent password.
* Retrieves the postgres connection using the connection id.
* Compare the passwords
* If the passwords are different update (or delete, create) the connection

And then the downstream tasks will use the updated connection via the 
connection id.

I get stuck in the last step, how do I update an airflow connection within an 
airflow DAG run?

One solution might be "obvious": I call a subprocess in the LocalExecutor to 
use the CLI...

but surely, there must be something better out there.




GitHub link: https://github.com/apache/airflow/discussions/63862

----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to: [email protected]

Reply via email to