BigQuery Failure Triage Agent with Root-Cause Card

Instead of just forwarding a cryptic BigQuery error, an agent gathers the context a human would: the failing SQL, the exact error and stack, recent changes to referenced tables, and whether other queries on the same source also broke. It synthesizes this into a readable root-cause hypothesis and suggested fix, attached to a Trello incident card.

Use it when scheduled-query failures land on a rotating on-call who lacks deep context on every pipeline. The agent does the first 20 minutes of triage so the responder opens the card already knowing the likely cause and next step.

1. 1A BigQuery scheduled-query failure event starts the run.
2. 2The agent fetches the error detail, the rendered query SQL, and metadata for every referenced table.
3. 3It checks recent schema or partitioning changes and looks for correlated failures across related transfer configs.
4. 4The agent reasons over the evidence to produce a ranked root-cause hypothesis and a concrete remediation suggestion.
5. 5It creates a Trello incident card with the analysis, evidence links, and a severity label, then drops a thread alert in Discord pointing on-call to the card.