[Amazon](500150) Error setting/closing connection: Connection timed out

Question

I am having connectivity issue from Glue console while trying to connect to Redshift Cluster. I am able to connect to Redshift cluster with exact credentials from my Desktop.

I have followed the AWS documentation and have "ALL TCP" connections open for Security Groups in which Redshift cluster resides. Both Glue and Redshift are in same Region. Also Glue has been given AWSRedshiftFullAccess.

I am running a wall and appreciate if you provide me guidance to resolve this issue. I followed the steps recommended in other thread but no luck (Ensuring that DNSHostname and DNSResolution enabled.

Appreciate your guidance.

Thanks,

V

Answer 1

Check if your redshiftcluster is ssl enabled or not, if it is SSL enabled, then you need to append the ssl config to the end of your host url. If ssl is not enabled, check the Security groups of your redshift cluster, it particularly needs TCP/Redshift port 5439 is open inbound.