Skip to content

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

@sfc-gh-jgriffith

Description

@sfc-gh-jgriffith

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.

sqlalchemy<2.0.0,>=1.4.0

Please answer these questions before submitting your issue. Thanks!

  1. What version of Python are you using?

    Python 3.8.16

  2. What operating system and processor architecture are you using?

    macOS-10.16-x86_64-i386-64bit

  3. 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

  4. What did you do?

    pip install snowflake-sqlalchemy

  5. What did you expect to see?

    Successfully installed snowflake-sqlalchemy-1.4.4

  6. Can you set logging to DEBUG and collect the logs?

Metadata

Metadata

Labels

enhancementThe issue is a request for improvement or a new featurestatus-fixed_awaiting_releaseThe issue has been fixed, its PR merged, and now awaiting the next release cycle of the connector.status-triage_doneInitial triage done, will be further handled by the driver team

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions