Re: [sqlalchemy] Re: How to connect to Amazon Redshift and Presto using SQLAlchemy?

2019-06-25 Thread Mike Bayer
please communicate with the sqlalchemy-redshift folks at https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/issues as I know nothing about what special options it offers On Tue, Jun 25, 2019, at 10:30 PM, Preutti Puawade wrote: > Hi, > > When I set engine as below, > > engine = > sa.c

[sqlalchemy] Re: How to connect to Amazon Redshift and Presto using SQLAlchemy?

2019-06-25 Thread Preutti Puawade
Hi I'm trying to connect like this engine = sa.create_engine('redshift+psycopg2://u...@hgst-edm-oregon-prod02.cgdmyxu24bfx.us-west-2.redshift.amazonaws.com:5439/bdpdw?tcpKeepAlive=true&ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory') no error came up print(engine.table_names())

[sqlalchemy] Re: How to connect to Amazon Redshift and Presto using SQLAlchemy?

2019-06-25 Thread Preutti Puawade
Hi, When I set engine as below, engine = sa.create_engine('redshift+psycopg2://usern...@xxx-edm-oregon-prod02.cgdmyxu24bfx.us-west-2.redshift.amazonaws.com:5439/bdpdw?tcpKeepAlive=true&ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory') it's no error. But when I try to print(engine.