We have a VPC enabled RDS read replica database, now I am trying to connect Quick Sight to this database and followed this article to setup VPC connection for Quick Sight.
After this setup I tried adding new Datasets using MySQl/MariaDB but there’s no successful connection. What am I missing here? Or there an other steps that I need to take?
Hello @Manoj_Virigineni, since you have Quick Sight enterprise edition, it might be worth filing a case with AWS Support where we can dive into the details further. Here are the steps to open a support case.
My initial thought is that you need to configure the permissions within RDS to allow the data to be passed into Quick Sight if all permissions are set up on the Quick Sight console. One of these links below may provide some more information:
Hello @Manoj_Virigineni, let me know if you have any remaining questions after speaking with support. Hopefully they are able to guide you towards a solution. Thank you!