Billy McMonagle

01/15/2021, 8:42 PM
Hi there, I'm wondering if there is a recommended way to include sql scripts as part of a flow? Perhaps using a custom base image with the sql files already loaded?
(Moved from #prefect-server, oops)


01/15/2021, 9:48 PM
Hi @Billy McMonagle - I think that's the most straightforward way to make that happen (since you're able to configure where in the container that script would live).
You might also consider some external repository for those scripts (maybe an S3 or GCS bucket) that would allow you to modify them independent of your flow.

Billy McMonagle

01/15/2021, 9:50 PM
Thanks @nicholas that makes sense.
😄 1