Set up docs MCPAWS IAM database authentication setup is documented in each ClickPipes source guide. Choose the guide that matches your database engine and AWS service:
- Amazon RDS for PostgreSQL
- Amazon Aurora PostgreSQL-Compatible Edition
- Amazon RDS for MySQL
- Amazon Aurora MySQL-Compatible Edition
- Amazon RDS for MariaDB
This compatibility page preserves links to sections of the previous shared guide. Use the links below to open the IAM authentication section in your source-specific guide.
Setup
Before you start
Enable IAM authentication
Open the matching IAM authentication section:
- PostgreSQL on Amazon RDS
- PostgreSQL on Amazon Aurora
- MySQL on Amazon RDS
- MySQL on Amazon Aurora
- MariaDB on Amazon RDS
Create the database user
Open the matching IAM authentication section:
- PostgreSQL on Amazon RDS
- PostgreSQL on Amazon Aurora
- MySQL on Amazon RDS
- MySQL on Amazon Aurora
- MariaDB on Amazon RDS
Obtain the ClickHouse service IAM role ARN
Open the matching IAM authentication section:
- PostgreSQL on Amazon RDS
- PostgreSQL on Amazon Aurora
- MySQL on Amazon RDS
- MySQL on Amazon Aurora
- MariaDB on Amazon RDS
Set up the IAM role
Obtain the RDS or Aurora resource ID
Open the matching IAM authentication section:
- PostgreSQL on Amazon RDS
- PostgreSQL on Amazon Aurora
- MySQL on Amazon RDS
- MySQL on Amazon Aurora
- MariaDB on Amazon RDS
Create the IAM role
Open the matching IAM authentication section: