Is My SQL Query Going To Break Production?

A senior data engineer identifies SQL query pitfalls that can trigger nasty errors — and even break your data pipelines.

Zach Quinn
Learning SQL
Published in
5 min readApr 18, 2024

--

When I was learning how to drive a two-prop boat, the captains assigned to train me all had their unique ways of irritating me. But, incidentally enough, it was the calmest one that got me into the most trouble. Where the others would bark commands or rip the wheel (sorry there’s no fancy nautical term for “wheel”) out of my trembling hands, this guy would…

--

--

Zach Quinn
Learning SQL

Journalist—>Sr. Data Engineer; helping you target, land and excel in data-driven roles.