SNOW-2402222: Dependency constraint on snowflake-connector-python prevents upgrade

[sparkiegeek]

1. What version of Python are you using?

   Python 3.13.3 (main, Aug 14 2025, 11:53:40) [GCC 14.2.0]

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

   Linux-5.15.167.4-microsoft-standard-WSL2-x86_64-with-glibc2.41

3. What are the component versions in the environment (pip freeze)?

   (not using pip directly - am using uv)

❯ uv tree | grep snowflake
Using CPython 3.13.3 interpreter at: /usr/bin/python3.13
Resolved 72 packages in 0.72ms
├── snowflake-connector-python v3.18.0
├── snowflake-sqlalchemy v1.7.7
│   ├── snowflake-connector-python v3.18.0 (*)

4. What did you do?

   Tried to upgrade snowflake-connector-python to the latest release (4.0.0), using uv lock --upgrade-package snowflake-connector-python==4.0.0

5. What did you expect to see?

   Upgrade of snowflake-connector-python to 4.0.0. Actually got an unsatisfiable dependency conflict

❯ uv lock --upgrade-package snowflake-connector-python==4.0.0
  × No solution found when resolving dependencies for split:
  ╰─▶ Because only snowflake-sqlalchemy<=1.7.7 is available and snowflake-sqlalchemy==1.7.7 depends on snowflake-connector-python<4.0.0, we can conclude that snowflake-sqlalchemy>=1.7.7 depends on
      snowflake-connector-python<4.0.0.
      And because your project depends on snowflake-connector-python==4.0.0 and snowflake-sqlalchemy>=1.7.7, we can conclude that your project's requirements are unsatisfiable.

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

   N/A

The constraint is at

snowflake-sqlalchemy/pyproject.toml

Line 41 in 3106287

dependencies = ["SQLAlchemy>=1.4.19", "snowflake-connector-python<4.0.0"]

and appears to be too conservative

[sfc-gh-dszmolka]

Talking about cutting edge @sparkiegeek ;) Python driver v4 was just released a couple hours ago. Indeed, the team will eventually need to adjust the constraints in this library too.

[Dejwwik]

My solution to fix the Snowflake connector dependency issue.

1. Pin the version of snowflake-connector-python in the pyproject.toml:

override-dependencies = [
    "snowflake-connector-python==4.0.0",
]

2. Install snowflake-sqlalchemy:

uv add snowflake-sqlalchemy

This works because it tells the package manager to install snowflake-sqlalchemy and,
if it encounters a dependency on snowflake-connector-python, do not use the version
required by snowflake-sqlalchemy, but always use the version in override-dependencies.

[sfc-gh-dszmolka]

this should now be resolved with the release of v1.8.0 ! (https://github.com/snowflakedb/snowflake-sqlalchemy/releases/tag/v1.8.0)