Unable to resolve Redshift hostname

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 ?

1 Like

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.

Regards - Sanjeeb

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?