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.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.table_names()) > > it gave me this error > > *ProgrammingError*: (psycopg2.ProgrammingError) invalid dsn: invalid > connection option "tcpKeepAlive" (Background on this error at: http://sqlalche.me/e/f405) > > and then I try this way > > engine = > sa.create_engine('redshift+psycopg2://usern...@xxx-edm-oregon-prod02.cgdmyxu24bfx.us-west-2.redshift.amazonaws.com:5439/bdpdw') > > then print(engine.table_names()) > > it gave me this error message > > *OperationalError*: (psycopg2.OperationalError) fe_sendauth: no password > supplied (Background on this error at: http://sqlalche.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 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. >> >> jdbc:presto://bdp-e2e-presto.xxx.com:xxxx/hive?user=x...@xxxx.com&SSL=true&SSLTrustStorePath=C:/Users/Downloads/bdp-ts.jks >> >> jdbc:redshift://xxx-edm-oregon-prod02.cgdmyxu24bfx.us-west-2.redshift.amazonaws.com:xxxx/bdpdw?tcpKeepAlive=true&ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory >> >> jdbc:redshift:iam://bdp-dp-redshift-hdd01:us-west-2/drive?tcpKeepAlive=true&ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory&plugin_name=com.amazon.redshift.plugin.AdfsCredentialsProvider&idp_host=access.xxxx.com&idp_port=xxx&DbGroups=grp_hdd_r&preferred_role=arn:aws:iam::xxxxxxxxxxxx:role/AWS-BDP-ENG-REDSHIFT-HDD-Prod >> >> Couple weeks ago I'm try to use sqlalchemy to connect to those databases. >> But I don't know how can I fit the above information into standard form of >> sqlalchemy like >> >> dialect+driver://username:password@host:port/database >> >> I'm trying this >> >> create_engine('jdbc:postgres:redshift://hgst-edm-oregon-prod02.cgdmyxu24bfx.us-west-2.redshift.amazonaws.com:xxxx/bdpdw?tcpKeepAlive=true&ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory/vqaa') >> >> and error message came up like this. >> >> *ArgumentError*: Could not parse rfc1738 URL from string >> 'jdbc:postgres:redshift://hgst-edm-oregon-prod02.cgdmyxu24bfx.us-west-2.redshift.amazonaws.com:xxxx/bdpdw?tcpKeepAlive=true&ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory/vqaa' >> >> Please kindly advise. >> >> thank you. > > -- > 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 sqlalchemy+unsubscr...@googlegroups.com. > To post to this group, send email to sqlalchemy@googlegroups.com. > 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/943e3114-4ac4-4b31-bfec-50e47994029b%40googlegroups.com > > <https://groups.google.com/d/msgid/sqlalchemy/943e3114-4ac4-4b31-bfec-50e47994029b%40googlegroups.com?utm_medium=email&utm_source=footer>. > For more options, visit https://groups.google.com/d/optout. -- 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 sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. 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/4ce98391-d392-4ad7-b223-95c298f70fed%40www.fastmail.com. For more options, visit https://groups.google.com/d/optout.