Almost a year ago, I wrote about learning to trigger a Python script with Airflow. Yesterday, I learned that over the course of that year, I may have been consistently missing a prevalent bug that has been giving us headaches while QAing the script. Let’s talk about the moduleNotFound error Local Testing …

At my job, I’m considered an authority on one specific product — our Events ETL Report (extract, transform, load). I get a lot of questions about the report, so I probably check Airflow logs that run its script a dozen times a day. Clients like to have their data as…

This week, a teammate asked me for design help as he considered adding a new row to an existing database table. As someone who has to work with a 26-column table every day, I wanted to help to see if there was a way to keep his from growing. …

Last week, I wrote about my experience using gRPC to process an API call that would make a SQL update. Since we were focusing on the gRPC part, we didn’t closely examine how we were using Java to make the update. …

I had my first experience with gRPC over a year ago, as I discussed in this post from August 2021. I’m sorry to say that I haven’t been working consistently with it since then, so I’ve had to re-learn a lot of the concepts. Further complicating things, our most common…

The last time I posted, I shared my experience debugging type adjustment with a pandas DataFrame. Around the same time I was writing that article, a friend of mine asked if I could do a presentation for one of our company’s Demo Days. I wanted to help him out and…

Python is my life now. Let that be a lesson to all the boot camp grads (like me) out there: I had never written a single line of Python code when I started my current job. Since then, I’ve taken one Udemy Python course and mostly learned through random docs…

I spent a couple of days struggling with encryption this week, so the weekend seemed like a perfect time to brush up as I hope to close the door on my issue Monday. Then, a funny thing happened. While I was searching Google to understand the syntax of one of…

I’m getting better at my job. This week, I got a request to update the data formatting on a report that we generate to match the format of data elsewhere. I knew exactly where to find the SQL that generated the data and it didn’t take much time to update…