Daily BigQuery Scheduled-Query Health Digest

Gives data teams a once-a-day rollup of every scheduled query's health instead of a stream of individual alerts. It counts failures and successes over the trailing day, flags queries that failed more than once, and distinguishes one-off blips from chronically flaky configs that need real attention.

Use it when you run dozens of scheduled queries and want trend visibility rather than per-event noise. It is the calm morning report that tells you what quietly broke overnight and which pipelines are degrading over time.

1. 1A daily schedule trigger fires each morning before standup.
2. 2An action pulls the run history for all scheduled queries in the project over the last 24 hours.
3. 3A logic step aggregates per-query success and failure counts and marks any query with repeated failures as a chronic offender.
4. 4For each chronic offender it opens a Trello card (deduplicated against existing open cards) so it does not get lost in the digest.
5. 5It posts a formatted Discord digest summarizing total runs, failures, recoveries, and the offender list.