Hey everyone, I have a flow in prefect that fetches data from Snowflake. However, whenever I run it, it keeps getting stuck in the fetch_all part and never comes out of it. Any thoughts?
s
Sean Williams
01/21/2025, 7:05 PM
I wonder if you're running into memory issues. Have you tried it with
fetch_one
or
fetch_many
and a smaller batch size?
t
Thaís Linzmaier
01/21/2025, 7:06 PM
Hey! The batch size is pretty small, less than 100 lines. I tried with fetch_many as well
s
Sean Williams
01/21/2025, 7:10 PM
Does the query history in Snowflake show that the query is being executed?
t
Thaís Linzmaier
01/21/2025, 7:22 PM
It didn't! I am trying new credentials now, thank you so much!