Hello everyone.
FYI I am using Quicksight Enterprise.
I am trying to create a new dataset in Quicksight by getting the data from my PostgreSQL 15 in RDS. I am getting this error:
Connection timed out. Check your data source network configurations.
For the “Show details”, it is:
|sourceErrorCode:|DATA_SOURCE_TIMEOUT|
|sourceErrorMessage:|Connection to the data source timed out before validation is complete.|
Now, I have been reading up a lot on this problem. I have essentially followed these two links:
My QuickSight cannot connect to RDS PostgreSQL DB via VPC - Question & Answer - Amazon QuickSight Community
Create a private connection from QuickSight to Redshift or RDS | AWS re:Post (repost.aws)
I have setup the security groups properly and did the following
- Created a PostgreSQL 13.12 using the same VPC with the new security groups - I can connect this RDS to Quicksight (validated connection)
- Used my original PostgreSQL 15 using the same VPC with the new same security groups - created a new user with md5 encryption. I can connect to the “Public network” using this md5 account. When I attempt to connect to my private subnet, I get the above connection timed out.
Now, I am pretty sure my security group works since the PostgreSQL 13.12 is able to connect. Furthermore, I believe that my user should be using md5 encryption since my PostgreSQL 15 using public network connection type works.
The issue is that I can’t connect it if I use my private subnet.
I am at a lost here. Any one can help me? Thanks.
Tldr: Created security group and used it on PostgreSQL 13.12 and 15.2. Created and used the same VPC connection in Quicksight for both. PostgreSQL 13.12 validated connection successfully when using VPC connection for connection type, but PostgreSQL 15.2 could not validate the connection when using the same VPC.