When attempting to set up a dataset connecting to an Aurora Postgres (version 14.13) reader instance, I am getting an error GENERIC_SQL_EXCEPTION with the message “The connection attempt failed”.
All other questions on this topic that I’ve found reference the authentication type (SCRAM vs MD5), but as you can see from this answer, Quicksight has fixed that issue. (The error message is also different).
I have a vpc connection set up for Quicksight, a security group set up for Quicksight, which is added as an allowable source for a new security group for the RDS instance. I also added a rule to the RDS security group to allow access from the Quicksight IP address range for data source connectivity.
The RDS instance and the quicksight VPC connection are in the same VPC.
I’ve tried using both the Aurora dataset connector and the RDS dataset connector.
I’d really appreciate any advice on how to resolve this issue.
Thanks!