unable to use snowflake-sqlalchemy connector

[josibake]

Trying to use the snowflake connector results in an error due to dependency conflicts. When building the image, you get the following errors:

ERROR: requests-oauthlib 1.3.0 has requirement oauthlib>=3.0.0, but you'll have oauthlib 2.1.0 which is incompatible.
ERROR: google-cloud-bigquery 1.24.0 has requirement six<2.0.0dev,>=1.13.0, but you'll have six 1.12.0 which is incompatible.
ERROR: pyopenssl 19.1.0 has requirement cryptography>=2.8, but you'll have cryptography 2.7 which is incompatible.
ERROR: oscrypto 1.2.0 has requirement asn1crypto>=1.0.0, but you'll have asn1crypto 0.24.0 which is incompatible.
ERROR: snowflake-connector-python 2.2.1 has requirement asn1crypto<2.0.0,>0.24.0, but you'll have asn1crypto 0.24.0 which is incompatible.
ERROR: snowflake-connector-python 2.2.1 has requirement boto3<1.12,>=1.4.4, but you'll have boto3 1.12.12 which is incompatible.
ERROR: snowflake-connector-python 2.2.1 has requirement botocore<1.15,>=1.5.0, but you'll have botocore 1.15.12 which is incompatible.
ERROR: snowflake-connector-python 2.2.1 has requirement idna<2.9, but you'll have idna 2.9 which is incompatible.
ERROR: snowflake-connector-python 2.2.1 has requirement requests<2.23.0, but you'll have requests 2.23.0 which is incompatible.

Not sure of the best way to solve this, considering a lot of these dependencies are coming from the upstream package. At this point, though, connecting to snowflake doesn't work

[Spacerat]

I've hit this too. I'm using the image directly from Dockerhub, so I noticed it when actually trying to connect to snowflake. Hitting "Test connection" results in the following log

Unexpected error (boto3 1.12.47 (/usr/local/lib/python3.6/site-packages), Requirement.parse('boto3<1.12,>=1.4.4'), {'snowflake-connector-python'})
ERROR:superset.views.core:Unexpected error (boto3 1.12.47 (/usr/local/lib/python3.6/site-packages), Requirement.parse('boto3<1.12,>=1.4.4'), {'snowflake-connector-python'})