airbytehq / airbytehq/airbyte

Support IAM-based authentication on RDS for Postgres

Open
#15,015 8 comments 7 reactions 0 assignees View on GitHub
connectors/source/postgres frozen team/db-dw-sources type/enhancement
Dominant language
Python
Stars
22.1k
Forks
5.3k
PR merge metrics
PR metrics pending

Description

## Tell us about the problem you're trying to solve
Amazon RDS allows accessing Postgres, MySQL, and MariaDB databases using [IAM-based authentication](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/UsingWithRDS.IAMDBAuth.html). A question about this feature was [raised](https://airbytehq-team.slack.com/archives/C021JANJ6TY/p1658532551005969) in the community Slack.

## Describe the solution you’d like
We are currently using Hikari to connect to JDBC sources. [This post ](https://blog.jdriven.com/2021/06/configure-hikari-connection-pool-when-using-rds-iam/)describes a solution for Hiraki to use IAM-based authentication.

## Describe the alternative you’ve considered or used
Current workaround is to generate login/password specifically for Airbyte

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.