so flows work locally but ` file ` is not defined when prefe

Question

so flows work locally but ` file ` is not defined when prefect cloud runs the flow Any idea what the issue is

rectalogic · Answer

< Phillip Kelly>

rectalogic · Answer

so it sounds like ` file ` is not useable with GitHub storage <https github com PrefectHQ prefect issues 3529> What about other local assets that the flow needs to load that are in the github repo e g local sql files Will they even be accessible to the flow is prefect not checking out the repo when it runs the flow

rectalogic · Answer

what about relative imports from other modules in my github repo does the agent not checkout the entire github repository when running my flow

rectalogic · Answer

unbelievable I guess it s not supported at all I really don t understand the reasoning behind most of the decisions prefect makes <https github com PrefectHQ prefect issues 4574>

Kevin Kho · Answer

Yes the Github Storage only gets the Flow file We know this not user friendly so it is being re designed for Prefect 2 0 For Prefect 1 0 you need to package the dependencies in a container

Kevin Kho · Answer

Stuff like SQL files can be achieved with Git Storage <https docs prefect io orchestration flow config storage html loading additional files with git storage|here>

rectalogic · Answer

is there any way to make the Git Storage use `GITHUB ACCESS TOKEN` PAT env var or does it have to use a prefect secret or ssh privkey

Kevin Kho · Answer

I think no You need to use a Secret or the ssh key

rectalogic · Answer

ok we switched to Git storage and now ` file ` is correct e g ` tmp tmpxy6wy7bw cureatr flows ` but we get `FileNotFoundError Errno 2 No such file or directory tmp tmpxy6wy7bw cureatr flows patient funnel patient funnel sql ` when trying to open a file relative to ` file ` that path seems correct Do we have to do something specific to make Git storage clone the entire repo

Kevin Kho · Answer

On that Prefect will clone the repo load in the SQL and then delete the files so it has to be read in outside of tasks when the script is ran

rectalogic · Answer

ugh ok You guys sure don t make anything easy

Kevin Kho · Answer

Yeah we know Git storage can t be the same form for sure for 2 0