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.