Consider a common scenario in data engineering: an engineer updates an upstream SQL transformation to calculate customer lifetime value. The query passes a local run, but once…