Assume role support for IAM Authentication for RDS for PostgreSQL

[petteja]

We need to assume an IAM Role before connecting to RDS for PostgreSQL using IAM Authentication.

Currently the only option is to create a custom AWS profile for this.

One solution might be to add an optional field to specify a role to assume in the data source configuration window.

[craigmaclachlan]

@petteja what does your custom profile look like? I'm trying to go cross-account to a redshift cluster so facing a similar issue.

[petteja]

[profile main-profile]
sso_start_url  = https://foobar.awsapps.com/start
sso_account_id = 012345678910
sso_role_name  = something
sso_region     = eu-north-1
region         = eu-north-1

[profile db-profile]
role_arn = arn:aws:iam::012345678910:role/db-access-role
source_profile = main-profile

I'm choosing the db-profile profile in IntelliJ.