Thread
#prefect-community
    Robert Esteves

    Robert Esteves

    3 months ago
    Hi all, I'm looking for some help with the following error: Failed to load and execute flow run: ModuleNotFoundError("No module named 'pyodbc'") We are running an Ec2 instance with the Prefect Docker Agent. --How do we install the Python modules? Is it needed on the Ec2 instance, (which we did) or is there a way to load it into the container? Thanks for your assistance and support.
    Kevin Kho

    Kevin Kho

    3 months ago
    Yes you would need it in the execution environment, so it needs to be in the container. This syntax will work as long as you use a base prefect image
    Anna Geller

    Anna Geller

    3 months ago
    connecting to a SQL Server DB from a Docker container can be challenging - I'd definitely recommend not starting your Dockerfile from scratch but googling a bit about how others tackled this since you need to ensure you have the DB driver and everything set up - not trivial (just a heads up to avoid your negative engineering here)
    Robert Esteves

    Robert Esteves

    3 months ago
    Thanks Kevin, and Anna. I really appreciate your help.