https://prefect.io logo
#prefect-community
Title
# prefect-community
a

Adam Roderick

12/07/2022, 5:08 PM
We are seeing some odd behavior when connecting to Snowflake from a task using the snowflake connector. This works:
for doc in query:
, but it appears to load the entire resultset into memory before enumerating the rows. The better practice is to use
Copy code
doc = query.fetchone()
while doc: 
  doc = query.fetchone()
However, this hangs immediately when run from within a task. Has anyone else seen this behavior? Any idea why it might be behaving this way?
Any help on this? @Dylan
d

Dylan

12/12/2022, 4:47 PM
Hey Adam 👋 I've let the team know you've got a question outstanding. Can you share a minimum reproducible example with us?
a

Adam Roderick

12/12/2022, 4:48 PM
Hey Dylan, this is the same issue as https://prefect-community.slack.com/archives/CL09KU1K7/p1670860398321709 so let's disregard this thread. Thank you
d

Dylan

12/12/2022, 4:53 PM
Gotcha, thank you 🙏
6 Views