SNOW-2464939: Snowpark Version Requirement

[jonny-samsung]

Description

I am using an image with snowflake-cli and snowflake-snowpark installed to handle all of my CI/CD pipeline. I am looking to start using the latest version of snowpark (1.40.0) because it has some implemented functions I need, but I just noticed that I am limited due to the version requirements of snowflake-cli. Currently, the snowpark package requirement is pinned at 1.33.0. Can we adjust this to be more flexible? Perhaps anything in the 1.X range should be suitable imo.

Reproduce With:

pip install snowflake-snowpark-python==1.40.0 snowflake-cli

Example Output:

INFO: pip is looking at multiple versions of <Python from Requires-Python> to determine which version is compatible with other requirements. This could take a while.
INFO: pip is looking at multiple versions of snowflake-snowpark-python to determine which version is compatible with other requirements. This could take a while.
ERROR: Cannot install snowflake-cli==3.10.0, snowflake-cli==3.10.1, snowflake-cli==3.11.0, snowflake-cli==3.12.0, snowflake-cli==3.2.2, snowflake-cli==3.3.0, snowflake-cli==3.4.1, snowflake-cli==3.5.0, snowflake-cli==3.6.0, snowflake-cli==3.7.0, snowflake-cli==3.7.1, snowflake-cli==3.7.2, snowflake-cli==3.8.0, snowflake-cli==3.8.1, snowflake-cli==3.8.2, snowflake-cli==3.8.3, snowflake-cli==3.9.0, snowflake-cli==3.9.1 and snowflake-snowpark-python==1.39.1 because these package versions have conflicting dependencies.

The conflict is caused by:
    The user requested snowflake-snowpark-python==1.39.1
    snowflake-cli 3.12.0 depends on snowflake-snowpark-python==1.33.0; python_version < "3.12"
    The user requested snowflake-snowpark-python==1.39.1
    snowflake-cli 3.11.0 depends on snowflake-snowpark-python==1.33.0; python_version < "3.12"
    The user requested snowflake-snowpark-python==1.39.1
    snowflake-cli 3.10.1 depends on snowflake-snowpark-python==1.33.0; python_version < "3.12"
    The user requested snowflake-snowpark-python==1.39.1
    snowflake-cli 3.10.0 depends on snowflake-snowpark-python==1.33.0; python_version < "3.12"
    The user requested snowflake-snowpark-python==1.39.1
    snowflake-cli 3.9.1 depends on snowflake-snowpark-python<1.26.0 and >=1.15.0; python_version < "3.12"
    The user requested snowflake-snowpark-python==1.39.1
    snowflake-cli 3.9.0 depends on snowflake-snowpark-python<1.26.0 and >=1.15.0; python_version < "3.12"
    The user requested snowflake-snowpark-python==1.39.1
    snowflake-cli 3.8.3 depends on snowflake-snowpark-python<1.26.0 and >=1.15.0; python_version < "3.12"
    The user requested snowflake-snowpark-python==1.39.1
    snowflake-cli 3.8.2 depends on snowflake-snowpark-python<1.26.0 and >=1.15.0; python_version < "3.12"
    The user requested snowflake-snowpark-python==1.39.1
    snowflake-cli 3.8.1 depends on snowflake-snowpark-python<1.26.0 and >=1.15.0; python_version < "3.12"
    The user requested snowflake-snowpark-python==1.39.1
    snowflake-cli 3.8.0 depends on snowflake-snowpark-python<1.26.0 and >=1.15.0; python_version < "3.12"
    The user requested snowflake-snowpark-python==1.39.1
    snowflake-cli 3.7.2 depends on snowflake-snowpark-python<1.26.0 and >=1.15.0; python_version < "3.12"
    The user requested snowflake-snowpark-python==1.39.1
    snowflake-cli 3.7.1 depends on snowflake-snowpark-python<1.26.0 and >=1.15.0; python_version < "3.12"
    The user requested snowflake-snowpark-python==1.39.1
    snowflake-cli 3.7.0 depends on snowflake-snowpark-python<1.26.0 and >=1.15.0; python_version < "3.12"
    The user requested snowflake-snowpark-python==1.39.1
    snowflake-cli 3.6.0 depends on snowflake-snowpark-python<1.26.0 and >=1.15.0; python_version < "3.12"
    The user requested snowflake-snowpark-python==1.39.1
    snowflake-cli 3.5.0 depends on snowflake-snowpark-python<1.26.0 and >=1.15.0; python_version < "3.12"
    The user requested snowflake-snowpark-python==1.39.1
    snowflake-cli 3.4.1 depends on snowflake-snowpark-python<1.26.0 and >=1.15.0; python_version < "3.12"
    The user requested snowflake-snowpark-python==1.39.1
    snowflake-cli 3.3.0 depends on snowflake-snowpark-python<1.26.0 and >=1.15.0; python_version < "3.12"
    The user requested snowflake-snowpark-python==1.39.1
    snowflake-cli 3.2.2 depends on snowflake-snowpark-python<1.26.0 and >=1.15.0; python_version < "3.12"

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

Context

I need support for the latest snowpark version in my CI/CD pipeline.