Incompatible versions of sqlalchemy between kedro[pandas]~=0.18 and kedro-viz~=6.0

[tsanikgr]

These 2 lines should probably be updated, as pip throws the following error when trying to install the latest versions of kedro[pandas] and kedro-viz:

The conflict is caused by:
    kedro[pandas] 0.18.7 depends on SQLAlchemy~=1.2; extra == "pandas"
    kedro-viz 6.0.0 depends on sqlalchemy~=2.0

[astrojuanlu]

Hello @tsanikgr, thanks for letting us know. I can confirm on Python 3.10:

> pip install "kedro[pandas]~=0.18" "kedro-viz~=6.0.0"
...
ERROR: Cannot install kedro-viz==6.0.0 and kedro[pandas]==0.18.0 because these package versions have conflicting dependencies.

The conflict is caused by:
    kedro[pandas] 0.18.0 depends on SQLAlchemy~=1.2; extra == "pandas"
    kedro-viz 6.0.0 depends on sqlalchemy~=2.0

To fix this you could try to:
1. loosen the range of package versions you've specified
2. remove package versions to allow pip attempt to solve the dependency conflict

ERROR: ResolutionImpossible: for help visit https://pip.pypa.io/en/latest/topics/dependency-resolution/#dealing-with-dependency-conflicts

[noklam]

Thanks for reporting that @tsanikgr, I am checking with viz why it is bumped to 2.0

[astrojuanlu]

To note, I also tried pip install "kedro" "kedro-datasets[pandas]>=1.0" "kedro-viz~=6.0.0" (had to add >1.0 to avoid backtracking to really old versions) and getting essentially the same error:

> pip install "kedro" "kedro-datasets[pandas]>=1.0" "kedro-viz~=6.0.0"
...
ERROR: Cannot install kedro-datasets[pandas]==1.0.0 and kedro-viz==6.0.0 because these package versions have conflicting dependencies.

The conflict is caused by:
    kedro-datasets[pandas] 1.0.0 depends on SQLAlchemy~=1.2; extra == "pandas"
    kedro-viz 6.0.0 depends on sqlalchemy~=2.0

[noklam]

Reopen the issue. The fix was merged but we haven't released a new version, will keep it open until then.

[tynandebold]

The new version is out now, so I'll close this again.