hey, not sure if this is the right place for this ...
# prefect-community
c
hey, not sure if this is the right place for this question, but: i installed prefect into a venv and am trying to run a script importing from the snowflake tasks. it gives me the error below. importing other tasks works and when i run
pip install prefect[snowflake]
it tells me everything is already installed.
c
Hi @Christian Eik - can you try to run
Copy code
import snowflake.connector as sf
within your environment
c
ok, i tried this and the error line i posted went away
which made me realize that were was a lot more above it that stays even if i run what you posted above
looks like azure is a requirement for snowflake
c
ah! that’s interesting; it appears that snowflake requires azure but
pip
isn’t picking that up
c
so i tried to install that and ran into another issue with the azure package
c
very surprising
c
yeah
so i tried installing azureml-dataprep via pip
but that doesn't seem to work with python 3.8 yet 😕
ok, not sure what's the next thing to try here for me. ideally i don't want to have to install the azure package at all since our snowflake runs on aws. so i don't think it's an issue that the snowflake package doesn't pick this up
c
i think you’re going to have to install the
azure
package as the python snowflake connector package requires it: https://github.com/snowflakedb/snowflake-connector-python/blob/master/setup.py#L161-L162
c
hmm these were already installed
c
based on the issue i linked above it appears you need to pin
azure-storage-blob
to
2.1.0
c
ah ok
let me try that
👍 1
works now
thanks a lot!
c
awesome - no problem!