SNOW-898480: Upper version constraint for cloudpickle of <=2.0.0 is too restrictive for python 3.11-compatible environments

[boyd-openai]

I'm working in a repository with the upgrade_constraint cloudpickle>=2.1 as a prerequisite for python 3.11 compatibility.

To use this library, if this constraint cannot be relaxed, I'll need to either fork it, but if this library ever plans to support python 3.11, it will need to relax this constraint anyway.

1. What version of Python are you using?

   3.9.13

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

macOS-13.5.1-arm64-arm-64bit

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

...
cloudpickle==2.0.0
...
snowflake-connector-python==3.1.0
snowflake-snowpark-python==1.6.1
...

4. What did you do?

   If possible, provide a recipe for reproducing the error.
   A complete runnable program is good.

5. What did you expect to see?

   Expected to be able to pip install snowflake-snowpark-python[pandas]; install failed because of unresolvable constraints.

[boyd-openai]

Running pip-compile:

Could not find a version that matches cloudpickle<=2.0.0,>=1.6.0,>=2.1 (from -c api/manage/upgrade_constraints.txt (line 72))
Tried: 0.1.0, 0.1.0, 0.1.1, 0.1.1, 0.2.1, 0.2.1, 0.2.2, 0.2.2, 0.3.0, 0.3.0, 0.3.1, 0.3.1, 0.4.0, 0.4.0, 0.4.1, 0.4.1, 0.4.2, 0.4.2, 0.4.3, 0.4.3, 0.4.4, 0.4.4, 0.5.0, 0.5.0, 0.5.1, 0.5.1, 0.5.2, 0.5.2, 0.5.3, 0.5.3, 0.5.4, 0.5.4, 0.5.5, 0.5.5, 0.5.6, 0.5.6, 0.6.0, 0.6.0, 0.6.1, 0.6.1, 0.7.0, 0.7.0, 0.8.0, 0.8.0, 0.8.1, 0.8.1, 1.0.0, 1.0.0, 1.1.1, 1.1.1, 1.2.0, 1.2.0, 1.2.1, 1.2.1, 1.2.2, 1.2.2, 1.3.0, 1.3.0, 1.4.0, 1.4.0, 1.4.1, 1.4.1, 1.5.0, 1.5.0, 1.6.0, 1.6.0, 2.0.0, 2.0.0, 2.1.0, 2.1.0, 2.2.0, 2.2.0, 2.2.1, 2.2.1
There are incompatible versions in the resolved dependencies:
  cloudpickle>=2.1 (from -c api/manage/upgrade_constraints.txt (line 72))
  cloudpickle<=2.0.0,>=1.6.0 (from snowflake-snowpark-python[pandas]==1.6.1->safety-apps (api/safety-apps/pyproject.toml))

[sfc-gh-aalam]

@boyd-openai unfortunately this is not a simple dependency update due to how we release the client to users and to stored-procs/udfs. We are aware of this issue and are working on it to update the dependency to 2.2.1.

[boyd-openai]

@sfc-gh-aalam - is there an issue tracking that to which I can subscribe?

[sfc-gh-aalam]

The tracking is internal to snowflake but you can watch the status of this PR as a proxy to see when this is done.

[boyd-openai]

Great, thank you! Happy to see you folks are already on this.