RedShift Serverless timeout when connecting with python

0

I tried to use redshift_connector to connect to my redshift cluster using python but I get a timeout error..

import redshift_connector

conn = redshift_connector.connect(
    host="default.XXXXXXXXX.us-east-1.redshift-serverless.amazonaws.com",
    database='dev',
    access_key_id="XXXXXXXXX",
    secret_access_key="XXXXXXX",
    port=5439,
    region="us-east-1"
 )

Result :

redshift_connector.error.InterfaceError: ('communication error', TimeoutError(10060, 

1- I am using my default workspace which uses my default VPC which has open inbound rules for IP and ports

2- I enabled public access to the workspace

wasted 3 hours on this and finaly used google bigquery ...

  • Have you tracked down exactly when the error is occurring. Is it during the connecting or is it when running an sql statement. I have seen this error with a bad sql statement which doesn't make sense but is something I have seen.

asked 2 years ago165 views
No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions