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ビュー
回答なし

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン