Re: [sqlalchemy] Re: pandas to MS SQL DataWarehouse (to_sql)

2018-10-12 Thread Jingting Lu
Hi Dirk, Happy to report that there are more projects using dw. I have the same issues here. Using Azure SQL DW at the moment and building a serverless function app that reads and sends data back to the SQL DW. Did you eventually find a solution other than looping through the dataframe?

Re: [sqlalchemy] SQLAlchemy Foreign Key Issues with Db2

2018-10-12 Thread Mike Bayer
hi there - for DB2 issues that's an external dialect supported by IBM, please post at https://groups.google.com/forum/#!forum/ibm_db On Fri, Oct 12, 2018 at 11:46 AM Brian T wrote: > > I'm running SQLAlchemy 1.2.12. When trying to autoload a DB2 table, it gives > me a "no such table" error

[sqlalchemy] SQLAlchemy Foreign Key Issues with Db2

2018-10-12 Thread Brian T
I'm running SQLAlchemy 1.2.12. When trying to autoload a DB2 table, it gives me a "no such table" error for a table referenced in a foreign key, even though that table exists. import sqlalchemy cnxstr = 'ibm_db_sa://xyzzy' db2 = sqlalchemy.create_engine(cnxstr) meta =