SQLAlchemy 2 Error

[zach-morris]

Using:

teradatasqlalchemy==17.0.0.4
SQLAlchemy==2.0.0

A simple connection now fails:

with my_teradata_engine.connect() as conn:
    print('test')

Error is:

ArgumentError: Additional keyword arguments are not accepted by this function/method.  The presence of **kw is for pep-484 typing purposes

[uyjeff18]

Hi zach-morris. Teradata is currently testing a new version of teradataml and teradatasqlalchemy that is compatible with sqlalchemy 2.0. This is targeted for release in late April 2023. Meanwhile, please stay on sqlalchemy 1.4.

[fvivian]

Hi @uyjeff18 what's the status on this issue? Furthermore, does it make sense to restrict the sqlalchemy version to sqlalchemy<2.0.0,>=1.4.0?

[uyjeff18]

Hi fvivian, zach-morris, good news is that we just released teradataml 17.20.00.04 last Friday. (a companion version of teradatasqlalchemy was also released) This version supports sqlalchemy 2.x. Please be aware though that there are code breaking changes (see release notes) due to sqlalchemy change. We're still working on documentation changes to include info on new functions/features. It will be out to https://docs.teradata.com/ soon. In the meantime, pls check the inline help for info.