Hi everyone
Looking for some help with enabling Snowfalke on our recently installed redash ami. I have looked throught his forum and followed what advice is here.
A snowflake.py runner was installed in query_runners by default
I have modified my .env file to include
REDASH_ADDITIONAL_QUERY_RUNNERS=redash.query_runner.snowflake
Restarted Apache and I still can’t see Snowflake as an available data source.
Just looking for a position as to whether Snowflake is supported or not.
I can verify the Snowflake connector is working on the redash server, but the query_runner fails when attempting to import the snowflake.connector. Therefore it never gets enabled
You need to install their Python connector (pip install snowflake-connector-python) along with enabling the query runner.
Now a word of caution: I removed snowflake-connector-python from our default builds, because it seemed to have dependencies that collide with our other dependencies. I think they changed these in some of the newer versions of their library, so we might enable it by default later on.
If you end up installing snowflake-connector-python and use this in your environment, I will appreciate if you report back if you stumbled at any issues or whether it’s safe to add back to the default builds.