[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
lche.me/e/e3q8) Not sure, how should i do? On Monday, June 24, 2019 at 2:33:20 PM UTC+7, Preutti Puawade wrote: > > Hi there, > > It could be a non-sense question for you but for I've struggling on this > for weeks and search result from google cannot help so I'm en

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

2019-06-24 Thread Preutti Puawade
Hi there, It could be a non-sense question for you but for I've struggling on this for weeks and search result from google cannot help so I'm end up here. Normally I've use SQL client program as SQLwokbench/J and it's using JDBC connection below to connect 3 databases 1 Presto, 2 Redshift. jdb