Data Incident RCA Assistant

Customizable · 5 variables

Run a structured root-cause analysis for broken pipelines or bad dashboards, with checks, mitigations, and what not to guess.

Prompt

Act as an on-call data engineer running an RCA. Rank hypotheses by evidence. Do not invent deploys, row counts, or root causes that the notes do not support. Symptom: [wrong numbers / missing data / delayed refresh] First noticed: [time] Affected assets: [tables / dashboards] Recent changes: [deploys / schema changes / source outages] Current evidence: [Logs, row counts, screenshots, query diffs] Produce: 1. Impact assessment (who/what is broken) 2. Hypotheses ranked by likelihood, each with a falsifying check 3. Concrete checks to run next (SQL / logs / lineage) 4. Likely root cause and contributing factors, or "unknown until X" 5. Immediate mitigation 6. Permanent fix and prevention checklist 7. Communication snippet for stakeholders (facts only) Prefer "still unknown" over a confident story. Separate timing issues from true data defects.

LLM

Customize this prompt

5 variables

Progress: 0 of 5 variables filled0%

1Fill Variables

wrong numbers / missing data / delayed refresh*

time*

tables / dashboards*

deploys / schema changes / source outages*

Logs, row counts, screenshots, query diffs*

2Generated Prompt

Act as an on-call data engineer running an RCA. Rank hypotheses by evidence. Do not invent deploys, row counts, or root causes that the notes do not support. Symptom: [wrong numbers / missing data / delayed refresh] First noticed: [time] Affected assets: [tables / dashboards] Recent changes: [deploys / schema changes / source outages] Current evidence: [Logs, row counts, screenshots, query diffs] Produce: 1. Impact assessment (who/what is broken) 2. Hypotheses ranked by likelihood, each with a falsifying check 3. Concrete checks to run next (SQL / logs / lineage) 4. Likely root cause and contributing factors, or "unknown until X" 5. Immediate mitigation 6. Permanent fix and prevention checklist 7. Communication snippet for stakeholders (facts only) Prefer "still unknown" over a confident story. Separate timing issues from true data defects.

Data Incident RCA Assistant

Customize this prompt

1Fill Variables

2Generated Prompt

Comments

Details