A critical Snowflake pipeline failed during month‑end reporting, and the business is waiting for the report. As the lead, how would you handle it?

S – The month‑end reporting pipeline in Snowflake failed, causing a delay in delivering the key financial report to stakeholders. T – My responsibility was to restore the report, minimize downtime, and prevent recurrence. A – I first acknowledged the issue to the business, then escalated to the engineering team. I pulled the latest logs, identified that a recent schema change caused a join to fail, and rolled back to the previous schema. I reran the pipeline on a test cluster to confirm the fix, then deployed the corrected job to production. Throughout, I kept the business updated with status and estimated resolution time. I also added a monitoring alert for schema changes and scheduled a post‑mortem. R – The report was delivered within the next hour, stakeholder confidence was restored, and we implemented automated schema validation to avoid similar failures in the future.