SNOW-739749: snowflake-sqlalchemy 1.4.4 requires sqlalchemy<2.0.0,>=1.4.0, but you have sqlalchemy 2.0.1 which is incompatible.

Error when attempting to install snowflake-sqlalchemy with sqlalchemy 2.0. Error:
snowflake-sqlalchemy 1.4.4 requires sqlalchemy<2.0.0,>=1.4.0, but you have sqlalchemy 2.0.1 which is incompatible.

Version 1.4.1 release notes say snowflake-sqlalchemy is now SQLAlchemy 2.0 compatible.

snowflake-sqlalchemy/setup.cfg

Line 50 in 7c8effd

sqlalchemy<2.0.0,>=1.4.0

Please answer these questions before submitting your issue. Thanks!

What version of Python are you using?

Python 3.8.16
What operating system and processor architecture are you using?

macOS-10.16-x86_64-i386-64bit
What are the component versions in the environment (pip freeze)?

asn1crypto==1.5.1
certifi @ file:///private/var/folders/sy/f16zz6x50xz3113nwtb9bvq00000gp/T/abs_477u68wvzm/croot/certifi_1671487773341/work/certifi
cffi==1.15.1
charset-normalizer==2.1.1
cryptography==38.0.4
filelock==3.9.0
greenlet==2.0.2
idna==3.4
oscrypto==1.3.0
pycparser==2.21
pycryptodomex==3.17
PyJWT==2.6.0
pyOpenSSL==22.1.0
pytz==2022.7.1
requests==2.28.2
snowflake-connector-python==2.9.0
SQLAlchemy==2.0.1
typing_extensions==4.4.0
urllib3==1.26.14
What did you do?

pip install snowflake-sqlalchemy
What did you expect to see?

Successfully installed snowflake-sqlalchemy-1.4.4
Can you set logging to DEBUG and collect the logs?

@sfc-gh-jgriffith

hey @sfc-gh-jgriffith, we're aware of the V2 GA release of sqlalchemy.
We will plan time for testing it and do release accordingly.

Do you have an estimated release timeframe for this?

Seconded the request for a timeframe, especially given that a previous version explicitly said it added compatibility.

We would like to use sqlalchemy 2.0 as well, but this is blocking - is there a release timeframe?

Any idea when sqlalchemy 2.0 support might land?

@sfc-gh-jgriffith

hey @sfc-gh-jgriffith, we're aware of the V2 GA release of sqlalchemy.

We will plan time for testing it and do release accordingly.

@sfc-gh-aling do you have any updates on this?

@sfc-gh-aling

Hi @sfc-gh-aling -- I see an update to snowflake-sqlalchemy just went out! Support for 2.0 yet!? As of this morning, it's still restricted to <2.0 upon installation.

https://pypi.org/project/snowflake-sqlalchemy/

Would also quite like to know a release timeframe for 2.0 support :)

@sfc-gh-aling

I was curious how close snowflake-sqlalchemy is from supporting sqlalchemy 2.0, so I manually installed it:

pip install --no-deps snowflake-sqlalchemy==1.4.6

It seems very close!

After some monkey-patching, I was able to create an engine and connect to snowflake:

def snowflake_sqlalchemy_20_monkey_patches():
    import sqlalchemy.util.compat

    # make strings always return unicode strings
    sqlalchemy.util.compat.string_types = (str,)
    sqlalchemy.types.String.RETURNS_UNICODE = True

    import snowflake.sqlalchemy.snowdialect

    snowflake.sqlalchemy.snowdialect.SnowflakeDialect.returns_unicode_strings = True

    # make has_table() support the `info_cache` kwarg
    import snowflake.sqlalchemy.snowdialect

    def has_table(self, connection, table_name, schema=None, info_cache=None):
        """
        Checks if the table exists
        """
        return self._has_object(connection, "TABLE", table_name, schema)

    snowflake.sqlalchemy.snowdialect.SnowflakeDialect.has_table = has_table

# usage: call this function before creating an engine:
snowflake_sqlalchemy_20_monkey_patches()

@sfc-gh-aling and snowflake team, for your 2.0 porting efforts, maybe 👆is helpful in assessing the gaps?

@sfc-gh-aling

@sfc-gh-aling Any updates?

Would love to see support for sqlalchemy 2 in snowflake-sqlalchemy!

#469 is closed. Should we consider this issue resolved?

Indeed! I'll close this issue once the version which is compatible with SQLAlchemy 2.0 is finally released.

Should we expect that version latest by autumn 2024 as mentioned above?

still don't have a definite and committed-to date from the Product team but I believe the plans to approach the release might have changed.
Just saw #514 so hopefully release v1.6.0 which is compatible with SQLAlchemy 2.0 is released way sooner than the original worst-case estimation of autumn 2024.

Look forward to that version. Thanks!

After such a long wait, release v1.6.0 is out ! This is the one bringing compatibility with SQLAlchemy 2.0 and can be right now downloaded directly from here.

For some reason it's not available on pip yet (still 1.5.3 is the latest) , we're working on this and will update this same thread.

edit: issue looks to be fixed, but due to the nature of the issue we'll need to release a new version (1.6.1) which will happen soon. will keep this thread updated as events evolve.

Thank you everyone again for bearing with us for such a long time !

Hooray 🎉! Thanks to all the team for working on this.

Excellent news, thanks to the team! Could you kindly comment here when 1.6.0 is available on PyPI and conda-forge? Our engineers might look at me funny if deployments involve downloading packages from some GitHub repository... (and I completely understand there is some kind of a delay, just trying to avoid having to poll both channels to see when we can update)

Excellent news, thanks to the team! Could you kindly comment here when 1.6.0 is available on PyPI and conda-forge? Our engineers might look at me funny if deployments involve downloading packages from some GitHub repository... (and I completely understand there is some kind of a delay, just trying to avoid having to poll both channels to see when we can update)

The publishing workflow was broken and they seem to have fixed it in #520, so I think it's just a matter of them creating a 1.6.1 release now.

It's out now 🙂

https://pypi.org/project/snowflake-sqlalchemy/1.6.1/

indeed ! aforementioned temporal issue with the release is now fixed, and v1.6.1 version of the library is now out.

This marks a big milestone, and again i would like to thank you all for your patience here ! Marking this issue as closed :)

Navigation Menu

Repository navigation

SNOW-739749: snowflake-sqlalchemy 1.4.4 requires sqlalchemy<2.0.0,>=1.4.0, but you have sqlalchemy 2.0.1 which is incompatible. #380

33 remaining items

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

SNOW-739749: snowflake-sqlalchemy 1.4.4 requires sqlalchemy<2.0.0,>=1.4.0, but you have sqlalchemy 2.0.1 which is incompatible. #380

Description

Activity

sfc-gh-aling commented on Feb 7, 2023

stuck1233333 commented on Feb 17, 2023

qwertystop commented on Feb 26, 2023

cladden commented on Mar 6, 2023

cpcloud commented on Mar 7, 2023

cladden commented on Mar 9, 2023

hellobrett commented on Mar 15, 2023

benoneill-tenzo commented on Mar 15, 2023

cladden commented on Mar 15, 2023

rosomri commented on Mar 30, 2023

cpcloud commented on Mar 30, 2023

33 remaining items

YarShev commented on Jul 2, 2024

sfc-gh-dszmolka commented on Jul 2, 2024

YarShev commented on Jul 2, 2024

sfc-gh-dszmolka commented on Jul 4, 2024

YarShev commented on Jul 4, 2024

sfc-gh-dszmolka commented on Jul 9, 2024

Mrfence97 commented on Jul 9, 2024

tvoipio commented on Jul 9, 2024

edgarrmondragon commented on Jul 9, 2024

edgarrmondragon commented on Jul 9, 2024

sfc-gh-dszmolka commented on Jul 9, 2024

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions