Jarrod Clark

    Jarrod Clark

    2 months ago
    Greetings. I am a bit of a Prefect noob, and I am having what seems on the surface to be a simple problem but I just can't figure it out. I have a flow that makes a SQL query, creates a pandas dataframe then uploads to an Elasticsearch index. When I use flow.run() in Jupyterlab it will run as expected, it registers with no errors but when I run it from the dashboard I receive the following error: 'FileNotFoundError: [Errno 2] No such file or directory: 'all_cases.sql' Anyone have any suggestions?
    Kevin Kho

    Kevin Kho

    2 months ago
    You can just start the agent in the same directory that has access to that sql file
    Jarrod Clark

    Jarrod Clark

    2 months ago
    TY! I knew I was doing something dunderheaded. Problem solved.
    Kevin Kho

    Kevin Kho

    2 months ago
    Or you can specify the working directory here
    Jarrod Clark

    Jarrod Clark

    2 months ago
    Thanks again