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.

질문됨 2년 전169회 조회
답변 없음

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인