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.

gefragt vor 2 Jahren169 Aufrufe
Keine Antworten

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen