Day 2 and of course I am falling behind on the blog already. I spent way too much time last night trying to figure out an issue I was having…and of course… it was an issue with my virtual environment, ugh!
My error was during video 1.2.2, while working in the jupyter notebook. The error was “SQLAlchemy - NoSuchModuleError: Can’t load plugin: sqlalchemy.dialects:postgresql.psycopg”
To try and figure out the cause of the error I searched the FAQ, the Slack Channel, searched google, and tried chatgpt, but could not figure it out. There was a somewhat similar post in the slack where the solution was the virtual environment, but for some reason I was ignorant and thought, no way! lol.
I got to the point where I needed help - so off to slack I went and posted:
Bruno Oliveira, one of the instructors this year, quickly responded. He was able to meet with me through Slack and he not only efficiently debuged and solve my issue, but taught me so much about virtual environments at the same time. Bruno is an outstanding teacher and I appreciate having him in this course, thank you - thank you Bruno! I was able to sleep soundly after this haa.
Now, the FAQ are now updated to include this error and the fact that the solution was my virtual environment. So lesson of the night, when in doubt, create a new environment and test to see if you’re still getting the same error message!
My plan is to add a virtual environment section to my notes in Gitbook
Interested in joining the course?! I am writing this 1/14/25 and you can still join the Data Engineering Zoomcamp Cohort 2025 or if you’re late to reading this, the material should still live there.