merlin
02/03/2023, 7:14 PM# local files
~/my_prefect_repo
|-- src/
|-- tables -> ../sql_files_repo/tables/
~/sql_files_repo
|-- tables/
|-- table_one.sql
|-- table_two.sql
--upload
will gather the symlinked SQL files and upload them to s3 or local storage location.
For Docker, I copy both repos into the container so the SQL scripts are also available to the flow code.
I don't know how this would work for github or S3 storage however, because only one storage block can be added to the deployment.