Extract. Transform. Read.A newsletter from Pipeline Hi past, present or future data professional! Despite falling into the realm of engineering, data infrastructure construction is a bit like basic art. At times building a data pipeline is as simple as filling in one of those color-by-numbers books. Other times, the process of extracting and ingesting data can be as abstract and disconnected as paint flicked onto a canvas, Jackson Pollack style. No matter the complexity of your build, there are always certain brushes, a.k.a. non-negotiables, you should paint with to create intuitive and robust pipelines. I consider the following recommendations to be non-negotiable because they serve the most basic goal of a data pipeline: Providing reliable, prompt and accurate data to data consumers. A non-negotiable you must include in not only data pipelines, but programmatic scripts at large, is a clear, consistent and accessible form of logging. Good logs will concisely reflect what is going on within a script, revealing insights about each function or step as it is executed. Learn more about the importance of logging and best practices here. Going hand-in-hand with logging is the capturing of and reference to API status codes. While not all APIs will emit similar text messages when a response is triggered, there are universal codes like 200 that can be helpful in indicating the presence of data or other attributes and distinguish an unsuccessful request from a successful effort. Once you have the data, I’d suggest, as a non-negotiable, that you keep it in a consistent format. It might be nice being able to iterate through columns in a data frame, convert it to JSON, and then convert to a final data frame, but the resources required to execute the transformations and redundancy of the operations makes this inefficient. If you have to do significant work to unnest data, for instance, it may be better and more efficient to keep your data in JSON form. Finally, one of the worst things a pipeline can do (after breaking) is generate duplicate data. Nearly every one of my work builds includes what I call a “refresh” query that deletes the current date’s data as the pipe runs. This means that if the pipeline has to run again, it will generate the exact same output. The word for maintaining state like this is “idempotent.” In an org running hundreds of pipelines, you don’t want to create the 1 pipe with an uncontrollable output. To review, non-negotiables include:
This week's links:
What did I miss? Reply to this email and let me know. Thanks for ingesting, -Zach Quinn |
Top data engineering writer on Medium & Senior Data Engineer in media; I use my skills as a former journalist to demystify data science/programming concepts so beginners to professionals can target, land and excel in data-driven roles.
Extract. Transform. Read. A newsletter from Pipeline Hi past, present or future data professional! If you haven’t heard "Happy New Year" enough in the past week… let me be, hopefully, the last to say it as we embrace all 2025 has to offer. Beginning a new year comes with the inevitable conception (and ultimately ignorance) of a new year’s resolution. Instead of focusing on one abstract goal to improve, I’d like to suggest, instead, that you form lasting habits, especially when it comes to...
Extract. Transform. Read. A newsletter from Pipeline Hi past, present or future data professional! In 2024 I published roughly 75 stories, mostly about data engineering or technology; understandably, with the pace of life and media, you most likely missed something I hope you’ll find valuable and actionable. Keeping with one of my core beliefs, that data-driven tools should result in both professional enrichment and reduce personal problems, my methodology for picking stories out of that...
Extract. Transform. Read. A newsletter from Pipeline Hi past, present or future data professional! If you’ve ever seen the legendary American sitcom Seinfeld, you might be familiar with the fictional holiday the characters create, festivus, “A festival for the rest of us.” As a rejection of conventional winter holidays like Christmas/Haunnukah, a core part of festivus is the “airing of grievances.” While I have yet to attempt this in real-life, I’ve spent the past two years airing my...