[BUG] - Snowflake dependency Error

[yeshwanthjagannath]

Description

Getting snowflake dependency errors when upgrading to 0.95.0 and above. Using poetry for dependency management. The error as reported below:

The current project's supported Python range (>=3.12,<4.0) is not compatible with some of the required packages Python requirement:

• snowflake requires Python <3.12,>=3.8, so it will not be satisfied for Python >=3.12,<4.0
  Because no versions of snowflake match >1.0.2,<2.0.0
  and snowflake (1.0.2) requires Python <3.12,>=3.8, snowflake is forbidden.
  So, because altigen-ensemblesai-backend depends on snowflake (^1.0.2), version solving failed.

• Check your dependencies Python requirement: The Python requirement can be specified via the python or markers properties
  For snowflake, a possible solution would be to set the python property to ""

Steps to Reproduce

1. Use poetry for dependency management
2. Run poetry add "crewai[tools]@^0.98.0" --python ">=3.12,<3.13"
3. Try to run your application and you will be given the above error.

Expected behavior

Code should compile without errors, but I get dependency errors

Screenshots/Code snippets

A basic poetry run will give the error.

Operating System

Windows 11

Python Version

3.12

crewAI Version

^0.95.0

crewAI Tools Version

^0.32.0

Virtual Environment

Poetry

Evidence

The current project's supported Python range (>=3.12,<4.0) is not compatible with some of the required packages Python requirement:

• snowflake requires Python <3.12,>=3.8, so it will not be satisfied for Python >=3.12,<4.0
  Because no versions of snowflake match >1.0.2,<2.0.0
  and snowflake (1.0.2) requires Python <3.12,>=3.8, snowflake is forbidden.
  So, because altigen-ensemblesai-backend depends on snowflake (^1.0.2), version solving failed.

• Check your dependencies Python requirement: The Python requirement can be specified via the python or markers properties
  For snowflake, a possible solution would be to set the python property to ""

Possible Solution

Snowflake connector python version needs to be updated or CrewAI python version needs to be downgraded. Snowflake requires a python version of >=3.8,<3.12

Additional context

NA

[chadsly]

I had this issue on Monday and I believe it was because of the crewai_tools update. I rolled back to "crewai-tools==0.25.8" and everything was back up and running.

[yeshwanthjagannath]

@chadsly - Thanks, but unfortunately, crewai-tools v0.25.8 is only compatible with crewai upto v0.86.0. If I upgrade to v0.95.0 and above, I continue to get the error, since v.025.8 is not compatible.