SageMaker notebook failed to make connection with RedShift Cluster

Question

Hi,
I wanted to access server based RedShift cluster from Amazon SageMaker. While trying to connect I got the error message saying

connection to server at "rbs-etl-cluster.czjmmqlrqoy1.us-east-1.redshift.amazonaws.com" (52.201.194.249), port 8192 failed: Connection timed out
Is the server running on that host and accepting TCP/IP connections?

What does this error indicate and how to find the VPC, subnet and security groups of the RedShift.

Michael Shapira · Accepted Answer

![Enter image description here](/media/postImages/original/IMVK_yeTpNTn2RYcnhTcARdA)

![Enter image description here](/media/postImages/original/IMmBH0os4aQn-tn6A7VFmeIg)

Also check this one:
https://github.com/aws-samples/sagemaker-processing-reading-data-from-redshift-to-sagemaker-pipelines/blob/main/redshift-sagemaker-pipeline.ipynb

Oleksii Bebych · Answer

You can find a Redshift network configuration in "Properties -> Network and security settings"

![Enter image description here](/media/postImages/original/IMrHV5X-k4Qua--skme-XVOA)
![Enter image description here](/media/postImages/original/IMQd3nOWVyRYi3o2XagAbZjQ)

The standard Redshift port is 5439, so usually you have to allow incoming traffic to 5439 in the Redshift security group

Why it's trying to connect to 8192 - it's a question. Maybe you configured a non standard port

`Connection timed out` means that Security Group or Network ACL does not allow connection (usually it's Security group), or your Sagemaker and Redshift are located in different VPCs and you did not complete a networking configuration (VPC peering and routing rules)

SageMaker notebook failed to make connection with RedShift Cluster

Add your answer

Relevant content