Amazon QuickSight data source connection error

This error indicates that QuickSight doesn't have the necessary permissions to access your Amazon Redshift database. To resolve this issue, you'll need to grant QuickSight the appropriate permissions.

First, verify that QuickSight is authorized to access your AWS resources. In the QuickSight console, navigate to your account settings and check the "Security & permissions" section. Ensure that QuickSight has been granted access to the necessary AWS services, including Amazon Redshift.

Next, check your IAM role policies. QuickSight uses a service role that needs proper permissions to access Redshift. Verify that the QuickSight service role has the required IAM permissions to connect to and query your Redshift cluster.

If your Redshift cluster is in a private VPC, you'll also need to configure VPC connections in QuickSight. Make sure the VPC connection is properly set up with the correct security group rules that allow QuickSight to communicate with your Redshift cluster. The security groups associated with your Redshift cluster should allow inbound traffic from the QuickSight VPC connection security group.

Additionally, verify that your Redshift cluster's resource policies allow access from QuickSight, and confirm that you're using the correct connection information and valid database credentials when attempting to create the data source.

By systematically checking these permission layers - QuickSight account permissions, IAM roles, VPC configuration, and security groups - you should be able to resolve the connection error.
Sources
Quick Suite Datasource Connectivity Guide. | AWS re:Post
Data source connectivity issues for Amazon Quick Sight - Amazon Quick