Using pgbouncer and AIRFLOW__CORE__SQL_ALCHEMY_CONN_CMD

[jeff-cook]

Is anyone using pgbouncer and AIRFLOW__CORE__SQL_ALCHEMY_CONN_CMD and have any suggestions.

I'm using the current airflow helm chart version 1.18.0.

We use a service to create our psql user and password and stores the connection info in a secret that is not compatible with this helm chart, so we are using AIRFLOW__CORE__SQL_ALCHEMY_CONN_CMD #56747

I'm working on enabling pgbouncer in the chart. Currently with only

  pgbouncer:
    enabled: true

All the pods stand up correctly, but it looks like airflow doesn't use pgbouncer. I'm guessing this is due to our use of AIRFLOW__CORE__SQL_ALCHEMY_CONN_CMD. Which I don't see in use anywhere in the pgbouncer pod.