Skip to main content

​
Aws resources on RDS IAM Auth

AWS Reference Doc

​
Requirements

  1. AWS RDS Cluster with IAM auth enabled
  2. User on DB Cluster with IAM enabled
  3. IAM policy with permission on RDS connect
  4. Role with IAM policy attached
  5. IAM role attached to an EC2 instance on which openmetadata is deployed or ServiceAccount/Kube2Iam role attached to pod.

​
How to enable ADS RDS IAM Auth on postgresql

Set the environment variables 
  DB_USER_PASSWORD: "dummy"
  DB_PARAMS: "awsRegion=eu-west-1&allowPublicKeyRetrieval=true&sslmode=require&serverTimezone=UTC"
Either through helm (if deployed in kubernetes) or as env vars.
The DB_USER_PASSWORD is still required and cannot be empty. Set it to a random/dummy string.
When using IAM authentication for AWS RDS, you must still provide a dummy value for the DB_PASSWORD environment variable. OpenMetadata automatically handles the IAM credentials internally. Ensure the following parameters are set for successful connection:
  • DB_PARAMS=awsRegion=us-east-1&allowPublicKeyRetrieval=true&serverTimezone=UTC
  • DB_USE_SSL=true
These settings ensure proper token generation and secure communication with the RDS instance.