Avoiding connections

Hello Astronomer community,

Is it possible, without writing a plug in, to create a connection object in my dag, and pass that to an operator? My client doesn’t want us to use Airflow’s Connection store to store credentials.

I see this page (Managing Connections — Airflow Documentation), which does show how to create a connection object and uri, but operators like MySqlOperator seem to force you to provide a connection id string, not the uri or object.

Any guidance here is greatly appreciated.

This may be helpful with what you want to do. You can possible create a connection and define the connection ID, commit it, then pass it to your MySqlOperator.