Cory Jez

05/13/2022, 3:29 PM
hi all - i am getting a pickling error on something related to SQLAlchemy when i go to register my flows to s3 (AWS prefect cloud setup). I recently tweaked some db connections (snowflake) to make them more performant; but can't find anything in SO related to this. has anyone ever seen something like this before?

Kevin Kho

05/13/2022, 3:42 PM
Hi @Cory Jez, you can store your Flow as a script to avoid it. The thing is you have something like a global client used by tasks that is getting serialized along with your Flow
You can learn more abotu script based storage. You can just say
and give the path of the script to upload
👀 1

Cory Jez

05/13/2022, 4:33 PM
@Kevin Kho thanks I will take a look