Uploaded June 2026 | Updated November 2026, 5 days ago
It’s 4:57 PM on a Friday, and a junior analyst noticed something odd.
The numbers in this week’s dashboard looked exactly like last week’s.
Not just similar.
Not kind of close.
Identical.
The pipeline had been rerunning but the data hadn’t changed for seven days, and nobody had a clue(until the CFO notices on a Monday morning).
Of course, maybe there is another story here about the fact that no one noticed that the data was stale, but let’s not get into that.
One of the challenges with data pipelines is that they can fail without anyone noticing.
Dashboards might only be looked at once a month.
Data can “look” right.
Pipelines can run without triggering any failure or red flag.
And what’s worse is that it can happen in multiple ways. In this article, I wanted to discuss the ways pipelines can fail silently and what you can do about it.
If you enjoyed this video, check out some of my other top videos.
Common Data Pipeline Patterns You’ll See in the Real World - Types Of Data Pipelines You'll Build
youtu.be/htAipJ6yYFs
What Is BigQuery - Breaking Down What BigQuery Is And Diving Into A Hands On Walkthrough
youtu.be/pud-vuNE15g
If you're looking for help ingesting your data in batch or real time, then you need to check out Estuary - bit.ly/4eQC3oQ
If you'd like to read up on my updates about the data field, then you can sign up for our newsletter here.
seattledataguy.substack.com/
Or check out my blog
theseattledataguy.com
And if you want to support the channel, then you can become a paid member of my newsletter
seattledataguy.substack.com/subscribe
Tags: Data engineering projects, Data engineer project ideas, data project sources, data analytics project sources, data project portfolio
_____________________________________________________________
Subscribe: youtube.com/channel/UCmLGJ3VYBcfRaWbP6JLJcpA?sub_confirmation=1
_____________________________________________________________
About me:
I have spent my career focused on all forms of data. I have focused on developing algorithms to detect fraud, reduce patient readmission and redesign insurance provider policy to help reduce the overall cost of healthcare. I have also helped develop analytics for marketing and IT operations in order to optimize limited resources such as employees and budget. I privately consult on data science and engineering problems both solo as well as with a company called Acheron Analytics. I have experience both working hands-on with technical problems as well as helping leadership teams develop strategies to maximize their data.
*I do participate in affiliate programs, if a link has an "*" by it, then I may receive a small portion of the proceeds at no extra cost to you.
It’s 4:57 PM on a Friday, and a junior analyst noticed something odd.
The numbers in this week’s dashboard looked exactly like last week’s.
Not just similar.
Not kind of close.
Identical.
The pipeline had been rerunning but the data hadn’t changed for seven days, and nobody had a clue(until the CFO notices on a Monday morning).
Of course, maybe there is another story here about the fact that no one noticed that the data was stale, but let’s not get into that.
One of the challenges with data pipelines is that they can fail without anyone noticing.
Dashboards might only be looked at once a month.
Data can “look” right.
Pipelines can run without triggering any failure or red flag.
And what’s worse is that it can happen in multiple ways. In this article, I wanted to discuss the ways pipelines can fail silently and what you can do about it.
If you enjoyed this video, check out some of my other top videos.
Common Data Pipeline Patterns You’ll See in the Real World - Types Of Data Pipelines You'll Build
youtu.be/htAipJ6yYFs
What Is BigQuery - Breaking Down What BigQuery Is And Diving Into A Hands On Walkthrough
youtu.be/pud-vuNE15g
If you're looking for help ingesting your data in batch or real time, then you need to check out Estuary - bit.ly/4eQC3oQ
If you'd like to read up on my updates about the data field, then you can sign up for our newsletter here.
seattledataguy.substack.com/
Or check out my blog
theseattledataguy.com
And if you want to support the channel, then you can become a paid member of my newsletter
seattledataguy.substack.com/subscribe
Tags: Data engineering projects, Data engineer project ideas, data project sources, data analytics project sources, data project portfolio
_____________________________________________________________
Subscribe: youtube.com/channel/UCmLGJ3VYBcfRaWbP6JLJcpA?sub_confirmation=1
_____________________________________________________________
About me:
I have spent my career focused on all forms of data. I have focused on developing algorithms to detect fraud, reduce patient readmission and redesign insurance provider policy to help reduce the overall cost of healthcare. I have also helped develop analytics for marketing and IT operations in order to optimize limited resources such as employees and budget. I privately consult on data science and engineering problems both solo as well as with a company called Acheron Analytics. I have experience both working hands-on with technical problems as well as helping leadership teams develop strategies to maximize their data.
*I do participate in affiliate programs, if a link has an "*" by it, then I may receive a small portion of the proceeds at no extra cost to you.










