We are using Aurora for our Postgres DB in AWS, and discovered that they have a feature that allows clients to connect to Postgres using IAM roles instead of passwords. Airflow describes how to authenticate with AWS services:
Since I am already using IAM roles with pod service accounts I thought I could take advantage of this by adding the correct policy to the role:
But I do not know how configure the Astronomer Helm chart to use the IAM role for Postgres connections. Can someone tell how to achieve the configuration described by Airflow with Astronomer Helm chart?