Unable to resolve Redshift hostname

[Sanjeeb2022]

Hi @ajayed - Welcome to AWS Quick Sight community and thanks for posting the question. Can you please have a look on the below community blog which explained the connectivity between Quick Sight 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 Quick Sight SecGrp (Note down the security group id for Quick Sight SecGrp ) Set the Inbound and Outbound rules for these security groups…

Regards - Sanjeeb