the default postgres connector for dagster doesn't seem to support AWS IAM roles for authentication, wondering if anyone has a solution that doesn't involve using static db/rds credentials?

Maybe some combination of https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/rds.html#RDS.Client.generate_db_auth_token and https://docs.sqlalchemy.org/en/14/core/engines.html#generating-dynamic-authentication-tokens? It’s not supported out of the box by Dagster, but everything is using SqlAlchemy under the hood so you can maybe achieve this via subclassing or extending the existing Dagster classes.

thanks, will look into this

Sure - but you’ll need to take care to make sure it’s backward compatible. You can assign me if you open one.

sure. are there any contributor license agreements we need to sign? I don't see any in the guidelines

nope