[GitHub] [airflow] wolfier commented on issue #17453: SQLAlchemy constraint for apache-airflow-snowflake-provider installation

[GitBox <gi...@apache.org>]

wolfier commented on issue #17453:
URL: https://github.com/apache/airflow/issues/17453#issuecomment-894471816


   interestingly, I was unable to replicate with OSS Airflow. The installation process is little different for my environment so I'll look into that.
   
   Here is how I tested the OSS installation.
   
   I have a python base image.
   ```
   ➜  docker run -it python bash
   ```
   
   `pip` version 
   ```
   root@ba82f0d0529c:/# pip --version
   pip 21.2.2 from /usr/local/lib/python3.9/site-packages/pip (python 3.9)
   ```
   
   Installation with the [constraints for 2.1.0](https://raw.githubusercontent.com/apache/airflow/constraints-2.1.0/constraints-3.7.txt).
   ```
   root@f2aa35e4c573:/#  pip install apache-airflow==2.1.0 -c constraint.txt
   ...
   Successfully installed Babel-2.9.1 Flask-Babel-1.0.0 Flask-JWT-Extended-3.25.1 Flask-OpenID-1.2.5 Flask-SQLAlchemy-2.5.1 Mako-1.1.4 WTForms-2.3.3 alembic-1.6.2 anyio-3.3.0 apache-airflow-2.1.0 apache-airflow-providers-ftp-1.1.0 apache-airflow-providers-imap-1.0.1 apache-airflow-providers-sqlite-1.0.2 apispec-3.3.2 argcomplete-1.12.3 attrs-20.3.0 blinker-1.4 cattrs-1.6.0 certifi-2020.12.5 cffi-1.14.5 click-7.1.2 clickclick-20.10.2 colorama-0.4.4 colorlog-5.0.1 commonmark-0.9.1 croniter-1.0.13 cryptography-3.4.7 defusedxml-0.7.1 dill-0.3.1.1 dnspython-1.16.0 docutils-0.17.1 email-validator-1.1.2 flask-1.1.2 flask-appbuilder-3.3.0 flask-caching-1.10.1 flask-login-0.4.1 flask-wtf-0.14.3 graphviz-0.16 gunicorn-20.1.0 h11-0.12.0 httpcore-0.13.6 httpx-0.18.2 idna-2.10 importlib-resources-1.5.0 inflection-0.5.1 iso8601-0.1.14 isodate-0.6.0 itsdangerous-1.1.0 jinja2-2.11.3 jsonschema-3.2.0 lazy-object-proxy-1.4.3 lockfile-0.12.2 markdown-3.3.4 markupsafe-1.1.1 marshmallow-3.12.1 marshmallo
 w-enum-1.5.1 marshmallow-oneofschema-2.1.0 marshmallow-sqlalchemy-0.23.1 numpy-1.20.3 openapi-schema-validator-0.1.5 openapi-spec-validator-0.3.0 pandas-1.2.4 pendulum-2.1.2 prison-0.1.3 psutil-5.8.0 pycparser-2.20 pygments-2.9.0 pyjwt-1.7.1 pyrsistent-0.17.3 python-daemon-2.3.0 python-dateutil-2.8.1 python-editor-1.0.4 python-nvd3-0.15.0 python-slugify-4.0.1 python3-openid-3.2.0 pytz-2021.1 pytzdata-2020.1 pyyaml-5.4.1 rfc3986-1.5.0 rich-9.2.0 setproctitle-1.2.2 six-1.16.0 sniffio-1.2.0 sqlalchemy-1.3.24 sqlalchemy-jsonfield-1.0.0 sqlalchemy-utils-0.37.2 swagger-ui-bundle-0.0.8 tabulate-0.8.9 tenacity-6.2.0 termcolor-1.1.0 text-unidecode-1.3 typing-extensions-3.7.4.3 unicodecsv-0.14.1 werkzeug-1.0.1
   ```
   
   installed `SQLAlchemy` version
   ```
   root@ba82f0d0529c:/# pip list | grep -i sql
   apache-airflow-providers-sqlite 1.0.2
   Flask-SQLAlchemy                2.5.1
   marshmallow-sqlalchemy          0.23.1
   SQLAlchemy                      1.3.24
   ```
   
   Now, I will install `apache-airflow-providers-snowflake` 
   ```
   root@ba82f0d0529c:/# pip install apache-airflow-providers-snowflake==2.0.0
   ...
   Successfully installed apache-airflow-providers-snowflake-2.0.0 asn1crypto-1.4.0 azure-common-1.1.27 azure-core-1.17.0 azure-storage-blob-12.8.1 boto3-1.18.15 botocore-1.21.15 chardet-4.0.0 charset-normalizer-2.0.4 jmespath-0.10.0 msrest-0.6.21 oauthlib-3.1.1 oscrypto-1.2.1 pyOpenSSL-20.0.1 pycryptodomex-3.10.1 requests-2.26.0 requests-oauthlib-1.3.0 s3transfer-0.5.0 snowflake-connector-python-2.5.1 snowflake-sqlalchemy-1.2.5 urllib3-1.26.6
   ```
   
   The version remained the same 
   
   ```
   root@ba82f0d0529c:/# pip list | grep -i snowflake
   apache-airflow-providers-snowflake 2.0.0
   snowflake-connector-python         2.5.1
   snowflake-sqlalchemy               1.2.5
   
   root@ba82f0d0529c:/# pip list | grep -i sql
   apache-airflow-providers-sqlite    1.0.2
   Flask-SQLAlchemy                   2.5.1
   marshmallow-sqlalchemy             0.23.1
   snowflake-sqlalchemy               1.2.5
   SQLAlchemy                         1.3.24
   SQLAlchemy-JSONField               1.0.0
   SQLAlchemy-Utils                   0.37.2
   ```
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@airflow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org