Unable to resolve Redshift hostname

[ajayed]

I am trying to create a new dataset in Quicksight with Redshift as underlying datastore.
After providing the Redshift connection details to create new Dataset, I am getting error as "Unable to resolve the host . The Redshift IP is Public facing but still getting this error. Also, if Redshift is not public facing and can only be accessed via our corporate VPN, how to configure this in Quicksight ?

[Sanjeeb2022]

Hi @ajayed - Welcome to AWS QuickSight community and thanks for posting the question. Can you please have a look on the below community blog which explained the connectivity between QuickSight and Redshift.

Connect to database over VPC connection

Steps for connecting to private Redshift instance through VPC connection are given below. Same approach will work for other DBs. (Be sure to update port number and security group names based on DB) Create two security groups under VPC used for Redshift. We will create inbound rules in next step. Leave the default outbound rules as is. Redshift SecGrp QuickSight SecGrp (Note down the security group id for QuickSight SecGrp ) Set the Inbound and Outbound rules for these security groups …

Regards - Sanjeeb

[royyung]

To setup a QuickSight connection for a Redshift or RDS inside VPC, you may refer to this step by step guide Authorizing connections to Amazon OpenSearch Service - Amazon QuickSight

Regarding the public facing Redshift, did you try to connect from other tools to see if it is able to connect?