BigQuery Failure Auto-Remediation via bq CLI Script

Applies scripted fixes for the handful of failure modes your team already knows how to remediate by hand. A shell step runs `bq` CLI commands — recreate a missing staging table, refresh a materialized view, or grant a known service-account role — then re-triggers the query and checks whether the fix held.

Use it when the same two or three failures keep paging on-call and the manual fix is always identical. Codifying that fix into a guarded script turns a 15-minute interruption into a hands-off recovery, while still recording exactly what was changed.

1. 1A BigQuery scheduled-query failure event triggers the run.
2. 2A logic step matches the error fingerprint against a known-remediation playbook and exits to manual handling if there is no match.
3. 3A shell action runs the matching `bq` CLI remediation commands inside the guarded sandbox.
4. 4The workflow re-runs the scheduled query and reads the new status.
5. 5It writes the full command transcript and final outcome to a Trello card — closing it automatically if the fix succeeded, leaving it open and labeled if not.