Snowflake connection is not working

[sivankumar86]

trafficstars

Bug description

cryptography version conflict

How to reproduce the bug

1. add RUN pip install snowflake-sqlalchemy==1.5.0 or latest verion
2. run a docker build and it failed with cryptography dep error

Screenshots/recordings

#9 51.15 ERROR: pip's dependency resolver does not currently take into account all the packages that are installed. This behaviour is the source of the following dependency conflicts. #9 51.15 apache-superset 3.1.1 requires cryptography<41.1.0,>=41.0.2, but you have cryptography 42.0.5 which is incompatible.

Superset version

master / latest-dev

Python version

3.9

Node version

16

Browser

Chrome

Additional context

No response

Checklist

• [X] I have searched Superset docs and Slack and didn't find a solution to my problem.
• [X] I have searched the GitHub issue tracker and didn't find a similar bug report.
• [X] I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section.

[rusackas]

CC @sadpandajoe @john-bodley who might know more about the current state of the cryptography bump saga.

[sadpandajoe]

CC @sadpandajoe @john-bodley who might know more about the current state of the cryptography bump saga.

Looks like from the error message, it's Superset 3.1.1. Superset 4.0 will be using cryptography==42.0.4 once it's out to the public.

[mrn3]

So do we just have to wait until 4.0 comes out, or what combination of downgraded versions will work?

[sivankumar86]

i installed cryptography==41.0.7 after installing snowflake connector. it works fine but, dirty workaround.

pip install --no-cache snowflake-sqlalchemy==1.5.0 \
  cryptography==41.0.7

[mrn3]

Okay thanks - what version of superset are you on @sivankumar86 ?

[sivankumar86]

@mrn3 SUPERSET_VERSION=3.1.1

[rusackas]

wait until 4.0 comes out

It's been out for a while now. In fact 4.0.1rc1 is being voted on already :)

[mrn3]

Okay, I am installing those versions (superset 3.1.1) with the

pip install --no-cache snowflake-sqlalchemy==1.5.0 \
  cryptography==41.0.7

I am using the helm chart 0.12.7 and still having issues with "cryptography<41.1.0,>=41.0.2" errors.

I will keep trying, but maybe I will try bumping to latest on everything.