https://prefect.io logo
Title
c

Christian Eik

11/29/2019, 11:49 AM
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

Chris White

11/29/2019, 4:28 PM
Hi @Christian Eik - can you try to run
import snowflake.connector as sf
within your environment
c

Christian Eik

11/29/2019, 4:58 PM
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

Chris White

11/29/2019, 5:00 PM
ah! that’s interesting; it appears that snowflake requires azure but
pip
isn’t picking that up
c

Christian Eik

11/29/2019, 5:00 PM
so i tried to install that and ran into another issue with the azure package
c

Chris White

11/29/2019, 5:00 PM
very surprising
c

Christian Eik

11/29/2019, 5:00 PM
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

Chris White

11/29/2019, 5:18 PM
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

Christian Eik

11/29/2019, 5:22 PM
hmm these were already installed
c

Chris White

11/29/2019, 5:23 PM
based on the issue i linked above it appears you need to pin
azure-storage-blob
to
2.1.0
c

Christian Eik

11/29/2019, 5:23 PM
ah ok
let me try that
👍 1
works now
thanks a lot!
c

Chris White

11/29/2019, 5:26 PM
awesome - no problem!