How to Debug a Forecast Model Drop After a SQL Join Change

One Monday our demand forecast looked worse across almost every category. Nothing obvious had changed in the model code, and the feature store job showed green. The clue was that the error grew most on items with partial catalog data. A small SQL change had moved a left join condition into the where clause, so rows without a fresh category mapping were silently dropped before feature…