Cannot retrieve config from alternative secrets backend about airflow HOT 3 CLOSED

Thanks for opening your first issue here! Be sure to follow the issue template! If you are willing to raise PR to address this issue please do so, no need to wait for approval.

from airflow.

Hey,team.

Several clarifications.

I can confirm that SSM parameters by path /airflow/prod/variables/* and /airflow/prod/connections/* exist and I can fetch them from container via aws ssm get-parameters-by-path --path /airflow/prod/variables --recursive --no-cli-pager

When I remove [secrets] section from airflow.cfg, I can execute airflow info command OK. Though, for some reason it shows sql_alchemy_conn | sqlite:////opt/airflow/airflow.db even though I do have AIRFLOW__DATABASE__SQL_ALCHEMY_CONN_SECRET environmental variable set pointing to correct RDS endpoint.
Env var should be AIRFLOW__DATABASE__SQL_ALCHEMY_CONN

Thank you.

from airflow.

After some digging around in Cloudtrail, I noticed that airflow was trying to read SSM /ariflow/config/postgresql+psycopg2://... and that operation was failing. And the cause was a mistake in configuration, where I used AIRFLOW__DATABASE__SQL_ALCHEMY_CONN_SECRET instead of AIRFLOW__DATABASE__SQL_ALCHEMY_CONN. Now that env var is fixed and commands work as expected.
Closing the issue.

from airflow.