Unable to resolve Redshift hostname

[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