How to connect to a cluster in Amazon Redshift using SQLAlchemy?
I was running into the exact same issue, and then I remembered to include my Redshift credentials:
eng = create_engine('postgresql://[LOGIN]:[PASSWORD]@shippy.cx6x1vnxlk55.us-west-2.redshift.amazonaws.com:5439/shippy')
I don't think SQL Alchemy "natively" knows about Redshift. You need to change the JDBC "URL" string to use postgres
.
jdbc:postgres://shippy.cx6x1vnxlk55.us-west-2.redshift.amazonaws.com:5439/shippy
Alternatively, you may want to try using sqlalchemy-redshift
using the instructions they provide.