Connecting Python to Redshift through SSH and SQLAlchemy

Question

My current connection configuration is as follow, this is for redshift db

con=('postgresql://username:password@hostname:port/databasename')
    server = SSHTunnelForwarder(
        ('ssh host', 22),
        ssh_username="-",
        ssh_password="-",
        remote_bind_address=('db host', port)
        )
    
    server.start()
    local_port = str(server.local_bind_port)
    engine = sa.create_engine(con)
    
    ######## Reaches here then times out when reading the table
    df_read = pd.read_sql_table('tablename',engine)

However, the Redshift database also has an SSH, which might be affecting the connection? It creates the engine but when reading the SQL in pd.read_sql_query I reach this error.

 (psycopg2.OperationalError) could not connect to server: Connection timed out (0x0000274C/10060)
    Is the server running on host "xxx" (xxx) and accepting
    TCP/IP connections on port xxx?

(Background on this error at: http://sqlalche.me/e/e3q8)

Take a look at stackoverflow.com/questions/39813312/…

Eric Truett
– Eric Truett

2020-05-19 12:29:18 +00:00
Commented May 19, 2020 at 12:29 — Eric Truett
– Eric Truett, Commented May 19, 2020 at 12:29

Joe Harris · Accepted Answer · 2020-05-21 13:33:08Z

0

You cannot SSH into a Redshift cluster but you can use SSL to secure the connection.

answered May 21, 2020 at 13:33

Joe Harris

14.1k4 gold badges49 silver badges56 bronze badges

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

Collectives™ on Stack Overflow

Connecting Python to Redshift through SSH and SQLAlchemy

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related