Thread
#prefect-community
    Ben Fisher

    Ben Fisher

    5 months ago
    Hi All. Quick question on how to create a Flow that references external files. In my case, I’m going to run a set of perhaps a dozen queries against a database, and I obviously don’t want to embed the SQL. I’d like to store the SQL external in files. Is that something I can do?
    Kevin Kho

    Kevin Kho

    5 months ago
    Yes as long as the flow has access to the files. Where are the files stored?
    Ben Fisher

    Ben Fisher

    5 months ago
    What are my options? I could simply keep them on the agent server and reference them by path, right? I’m sure there are reasonable ways around parameterizing the directory location.
    Could I also store them in GitHub?
    Kevin Kho

    Kevin Kho

    5 months ago
    Check this if they are stored alongside the Flow in Git
    Ben Fisher

    Ben Fisher

    5 months ago
    This is exactly what I was looking for. The pattern looks like it’ll work for most storage systems.
    Kevin Kho

    Kevin Kho

    5 months ago
    If you are using
    Local
    agent, you can also use
    LocalRun
    with a specified working directory like the third example here