I have followed the steps in the guide to set up a secure connection between QuickSight and my RDS read replica but, short of making the DB totally accessible to all traffic, I can’t seem to make a secure connection work.
I’ve used the Reachability Analyzer which shows that the QuickSight network interface is able to connect to the database, I’ve even set up DNS resolver endpoints in case that would help, and whenever I try to restrict the source of traffic to the security group I have created and assigned to the VPC connection in QuickSight, I get a timeout issue.
Am I able to access a read replica endpoint from QuickSight or do I need to do something else in my setup to make it all work?