I have a database on Postgres that I would like to connect to on QuickSight. I am able to connect with the credentials to the database on pgAdmin, but when I click ‘Validation’ button on QuickSight with the same credentials, I am getting the error below.
Did anyone have the same issue as I am having? If so, how did you solve it?
Here are few resources to get started :
If it’s in a private subnet : Create a private connection from QuickSight to Redshift or RDS | AWS re:Post
Our documentation on connection to databases : Authorizing connections from Amazon QuickSight to Amazon RDS DB instances - Amazon QuickSight
Kind regards,
Koushik
Thank you for letting us know. I would recommend filing a case with AWS Support where we can dive into the details so that we can help you further. Here are the steps to open a support case. If your company has someone who manages your AWS account, you might not have direct access to AWS Support and will need to raise an internal ticket to your IT team or whomever manages your AWS account. They should be able to open an AWS Support case on your behalf. Hope this helps!