title: Connecting Python to Redshift through SSH and SQLAlchemy
body: <p>My current connection configuration is as follow, this is for redshift db</p>
  <pre><code>con=('postgresql://username:password@hostname:port/databasename')
      server = SSHTunnelForwarder(
          ('ssh host', 22),
          ssh_username=&quot;-&quot;,
          ssh_password=&quot;-&quot;,
          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)
  </code></pre>
  <p>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.</p>
  <pre><code> (psycopg2.OperationalError) could not connect to server: Connection timed out (0x0000274C/10060)
      Is the server running on host &quot;xxx&quot; (xxx) and accepting
      TCP/IP connections on port xxx?
  
  (Background on this error at: http://sqlalche.me/e/e3q8)
  </code></pre>