Superset unable to load snowflake driver on linux

[pradeepzat]

I receive the error below when I test the connection from superset to snowflake.
"ERROR: Could not load database driver: SnowflakeEngineSpec"

URI used: snowflake://username:[email protected]/DB_NAME

$ pip show snowflake-sqlalchemy | grep -i version
Version: 1.2.5
License: Apache License, Version 2.0
$ pip show sqlalchemy | grep -i version
Version: 1.3.24
$ pip show apache-superset | grep -i version
Version: 1.2.0
License: Apache License, Version 2.0

[JelenaKitanovic]

Same here on MacOS.

$ pip show snowflake-sqlalchemy | grep -i version
Version: 1.3.3
License: Apache License, Version 2.0

$ pip show sqlalchemy | grep -i version
Version: 1.4.7

[anilkulkarni87]

I am having the same issue on MacOS

[phil-hachey]

For those trying to deploy this on Kubernetes I found the "right mix" of dependencies that lets me create Snowflake datasources. Here's what my bootstrapScript block looks like:

bootstrapScript: |
  #!/bin/bash
  pip install 'psycopg2==2.8.5' \
    redis==3.2.1 \
    snowflake-sqlalchemy==1.2.4 \
    authlib==1.0.1 && \
  if [ ! -f ~/bootstrap ]; then echo "Running Superset with uid {{ .Values.runAsUser }}" > ~/bootstrap; fi

I also got this to work locally by including these lines in my ./docker/requirements-local.txt file in the apache/superset repository:

psycopg2==2.8.5
snowflake-sqlalchemy==1.2.4

Note that this worked with superset versions 1.4.1, 1.4.2 and 1.5.0