pandas and sqlalchemy compatibility

Error:

TypeError: init() got multiple values for argument ‘schema’

Error in:
pandas2.0.3 and sqlalchemy1.4.46

Original answer:

As you stated, a workaround is to downgrade to SQLAlchemy<2.0,

pip install --upgrade sqlalchemy==1.4.47
There is already a fix in pandas (https://github.com/pandas-dev/pandas/pull/48576). Either install pandas from git or wait for a new release.

Edit: @DrD pointed out that the commit is already merged and will be part of pandas 2.x, also the comments point to the probability of pandas < 2.0 never supporting SQLAlchemy 2.x.

Share
Edit
Follow
edited Apr 26, 2023 at 16:39
answered Feb 10, 2023 at 22:41
cabo’s user avatar
cabo
13711 silver badge1010 bronze badges
2
as of today (Mar 28) the issue is merged on master, but no release was done, it looks like it will be part of pandas 2.* which is hopefully released, soon. –
DrD
CommentedMar 28, 2023 at 15:06

方法三：安装sqlalchemy-databricks 以代替SQLAlchemy，前提把SQLAlchemy卸载干净，以防到时冲突报错。
21 Aug 2024