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())
and there is error like this
ProgrammingError: (psycopg2.ProgrammingError) invalid dsn: invalid connection
option "tcpKeepAlive"
(Background on this error at: http://sqlalche.me/e/f405)
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
so i try this
engine =
sa.create_engine('redshift+psycopg2://u...@hgst-edm-oregon-prod02.cgdmyxu24bfx.us-west-2.redshift.amazonaws.com:5439/bdpdw')
no error came up
however after try to
print(engine.table_names())
there is an error like this
OperationalError: (psycopg2.OperationalError) fe_sendauth: no password supplied
(Background on this error at: http://sqlalche.me/e/e3q8)
Please advise how to deal with this?
--
SQLAlchemy -
The Python SQL Toolkit and Object Relational Mapper
http://www.sqlalchemy.org/
To post example code, please provide an MCVE: Minimal, Complete, and Verifiable
Example. See http://stackoverflow.com/help/mcve for a full description.
---
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sqlalchemy.
To view this discussion on the web visit
https://groups.google.com/d/msgid/sqlalchemy/934f94a8-12d0-4b75-bb66-85e1f259d266%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
