merlin02/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
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.