Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Superset unable to load snowflake driver on linux #222

Open
pradeepzat opened this issue Aug 9, 2021 · 3 comments
Open

Superset unable to load snowflake driver on linux #222

pradeepzat opened this issue Aug 9, 2021 · 3 comments

Comments

@pradeepzat
Copy link

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
Copy link

JelenaKitanovic commented Jan 11, 2022

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
Copy link

I am having the same issue on MacOS
image

@phil-hachey
Copy link

phil-hachey commented May 13, 2022

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants