How to setup proxy for redshift_connector

Question

I'm trying to use redshift_connector by AWS to connect to my Redshift cluster.

To be able to connect, I first need to set up a proxy. Since redshift_connector doesn’t seem to have a dedicated parameter for proxy, I created and set an environment variable before creating the connection:

os.environ['HTTPS_PROXY'] = 'proxy_url'

However, the connection creation often times out, and it seems this is because of the proxy setting.

When I try using boto3 with redshift-data, and I supply the proxy inside the Config object:

config = Config(proxies={...})

…it works just fine.

Question:

Is there any other way to set up a proxy for redshift_connector?

I’d prefer using redshift_connector over boto3 so I can avoid active waiting for results.

Bill Weiner · Accepted Answer · 2025-10-03 14:58:55Z

0

I think you may be looking for an ssh tunnel. This is an edge ec2 instance as an internet visible ssh enpoint that can tunnel the connector port to you private Redshift instance. Does this sound like it addresses your need?

https://repost.aws/knowledge-center/private-redshift-cluster-local-machine

I've done this many times and works well since Redshift connections are done on a single port. If you have long running queries you may need to have to set up some "keep alive" packets to keep the port open as some network routers will time out active connections if they are idle too long. Not hard just something to watch out for. If this sounds right and the article doesn't help you get this set up just reach out.

answered Oct 3 at 14:58

Bill Weiner

11.4k2 gold badges12 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Martin Bedrna Oct 17 at 9:25

I am not able to setup ssh tunnel on the machine where the code should run.. I also found out that redshift_connector is unusable with SQLAlchemy for connection pooling (because the sqlalchemy-redshift is dead project). Given these two issues, I will use other solution than redshift_connector.

Collectives™ on Stack Overflow

How to setup proxy for redshift_connector

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related