Hi,
I'm experiencing difficulties connecting Google Data Studio to our AWS RDS PostgreSQL database via RDS Proxy using PostgresSQL connector available on the data connectors. I've taken the following steps to set up the connection, but I'm still unable to establish a successful link:
1. RDS and RDS Proxy Setup:
- Created an RDS PostgreSQL instance (PostgreSQL 12.20)
- Set up an RDS Proxy to manage connections to the database
- Enabled encryption and IAM DB authentication on the RDS instance
2. Security Configuration:
- Configured the RDS Proxy security group to allow inbound connections on port 5432 from the following IP ranges:
34.93.10.146/32, 34.93.102.253/32, 35.200.143.183/32, 35.200.183.209/32, 34.93.118.120/32
- Also allowed connections from the VPC CIDR and a specific EC2 instance security group
3. Database User Setup:
- Created a read-only user specifically for Google Data Studio access
- Granted necessary permissions: CONNECT, USAGE, and SELECT on required schemas and tables
4. SSL Configuration:
- Downloaded the Amazon RDS root certificate (ap-south-1-bundle.pem)
- Enabled SSL for the connection
5. Google Data Studio Connection Attempt:
- Host: [RDS Proxy Endpoint]
- Port: 5432
- Database: [Database Name]
- Username: [Read-only Username]
- Password: [Read-only User Password]
- SSL: Enabled, using the downloaded certificate
Despite these configurations, I'm unable to establish a connection. When testing the connection using psql from my local machine and I am able to connect. When testing from an EC2 instance within the same VPC, I am able to connect
I've verified that:
- The RDS instance is in an "available" state
- The RDS Proxy is properly configured and in an "available" state
- The security group allows connections from the necessary IP ranges
- The VPC and subnet configurations should allow the necessary connections
Could you please advise on any additional steps I should take or any potential issues that might be preventing the connection from Google Data Studio to our RDS database via the RDS Proxy?
Thank you for your assistance.
Best regards,
Roshan
User | Count |
---|---|
3 | |
3 | |
1 | |
1 | |
1 |