Airflow Connection to AWS Aurora DB w/IAM role

Airflow
1

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:

https://airflow.apache.org/docs/apache-airflow-providers-amazon/stable/connections/aws.html#authenticating-to-aws

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:

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/UsingWithRDS.IAMDBAuth.IAMPolicy.html

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?

2

It would be very nice to have it using IAM credentials to connect to AWS Postgres RDS as well.