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.

preguntada hace 2 años169 visualizaciones
No hay respuestas

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas