I have created a RedShift cluster inside a VPC, I am trying to connect it to the AWS Quicksight service.
I am using the link given below to enable access to RedShift for Quicksight.
In the above link I am refering to the “Manually enabling access to an Amazon Redshift cluster in a VPC” section, where I am creating a new security group
with inbound rule to allow Redshift access using Quicksight CIDR Address 18.104.22.168/27 used for us-east-1 region where my Redshift cluster is located.
Additionaly the cluster is set enabled to be accesed via public network as that’s what is required for AWS quicksight to connect in Standard edition.
After creating a new security group and assigning it to Cluster, when I try to create a new dataset using RedShift autodiscovery option,
I am facing the below given error:
Amazon Error setting/closing connection: SocketTimeoutException.
Please note that I am using the “Standard Edition” of AWS Quicksight.
Can anyone provide any solution around this.