https://prefect.io logo
Title
c

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?
k

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
stored_as_script=True
and give the path of the script to upload
👀 1
c

Cory Jez

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