Pipeline Error Troubleshooting
Diagnose and fix pipeline failures when production breaks or error messages turn cryptic.
Prompt Template
I'm experiencing issues with [SPECIFIC_PIPELINE_NAME or FOLDER].Please:1. Perform root cause analysis on recent pipeline failures2. Run diagnostics and identify failure points3. Check for common issues: - Missing tables or schema objects - Invalid component configurations - Data type mismatches - Missing variables or parameters4. Provide step-by-step remediation guidance with priority ranking
Industry Example
I'm experiencing issues with retail-analytics/daily_store_sales_rollup.orch.yaml.Please:1. Perform root cause analysis on recent pipeline failures2. Run diagnostics and identify failure points3. Provide step-by-step remediation guidanceAdditional context:- This pipeline started failing after we added 15 new stores last week- It's supposed to aggregate daily sales from all 165 stores into our executive dashboard- The error mentions something about "store_id not found" but worked fine before- Runs every night at 11 PM EST and needs to complete before 6 AM for morning reports