Using Redshift as data source for QuickSight

Question & Answer
, ,
1

Getting the below error, when trying to configure Redshift Serverless as data source.
I configured the inbound and outbound rules on quicksight sg, configured the inbound and outbound rules on redshift sg. After I did added Add VPC connection on quicksight as describe all steps on this doc Manually enabling access to an Amazon Redshift cluster in a VPC - Amazon QuickSight
After I gave the permissions on redshift like this:
– Grant SELECT privileges to admin user

GRANT SELECT ON pg_stats TO admin;

GRANT SELECT ON pg_class TO admin;

GRANT SELECT ON pg_namespace TO admin;

– Grant SELECT privileges to quicksight_user

GRANT SELECT ON pg_stats TO quicksight_user;

GRANT SELECT ON pg_class TO quicksight_user;

GRANT SELECT ON pg_namespace TO quicksight_user;

Your database generated a SQL exception. This can be caused by query timeouts, resource constraints, unexpected DDL alterations before or during a query, and other database errors. Check your database settings and your query, and try again.

Quick Sight can see the domains, but not abl to connect. OpenSearch domain is publicly accessible, so there is no connectivity issue.

Can you please help? Thank you!

2

Hi @Bruno_Barbosa_Nicola

Welcome to the QuickSight community!

Please refer to the below documentations this might be helpful for you, it may help if you’re using a private connection.

If this doesn’t resolve the issue. 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!