DEVOPS
Daily digest of the priciest BigQuery queries posted to Slack
Each morning queries INFORMATION_SCHEMA for yesterday's top jobs by bytes billed and posts a ranked Slack digest with cost, user, and a link to each query.
How it runs
The automated pipeline, trigger to output.
- TriggerDaily schedule
- ActionQuery INFORMATION_SCHEMA.JOBS for yesterday's costsBigQuery
- LogicRank and keep top offenders over threshold
- OutputPost ranked cost digest to SlackSlack
What it does
Once a day it reads BigQuery's job history, ranks the previous day's queries by bytes billed and estimated dollar cost, and posts the top offenders to a Slack channel. The team sees which queries, users, and scheduled jobs are driving spend without anyone logging into the console.
When to use it
Use it when you want a low-effort cost habit: a single channel where the data team reviews the worst queries each morning and decides what to tune. It surfaces trends a per-PR gate misses, like a cheap query that suddenly scans more after a table grows.
How it works
- 1A daily schedule triggers the flow each morning.
- 2A BigQuery query reads INFORMATION_SCHEMA.JOBS for the prior day, summing bytes billed per job.
- 3A logic step ranks jobs and keeps the top N over a cost threshold.
- 4The flow formats each row with user, table, bytes billed, and estimated cost.
- 5A ranked digest is posted to Slack with one line per offending query.
Set it up
What you configure once, before turning it on.
- 1Connect BigQueryDatasets, queries, schemas.
- 2Connect SlackChannels, DMs, threads, mentions.
- 3Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 4Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 5Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.
More DevOps workflows
Slack-approved pause for idle Hugging Face Spaces
On a daily scan it finds idle paid Spaces and posts an interactive Slack approval; on approve it pauses the Space and logs the decision to a GitHub issue audit trail.
Block costly Hugging Face Space hardware upgrades in PR review
When a pull request changes a Space's hardware config, it estimates the new monthly cost and posts a GitHub PR comment that flags upgrades crossing a budget ceiling.
Hugging Face Spaces idle-runtime sweep with auto-pause
On a schedule, scans all Hugging Face Spaces for ones running idle past a threshold, pauses them to stop billing, and posts a Slack summary with the estimated monthly savings.
Open a Zoom war-room from a Datadog multi-alert storm
When a Datadog monitor crosses a critical threshold, this workflow dedupes against active incidents, and only for a genuinely new outage it creates a Zoom bridge.
Auto-spin a Zoom war-room when PagerDuty hits SEV-1
When a PagerDuty incident escalates to a critical severity, this workflow creates a dedicated Zoom meeting and posts the bridge link to the incident's Slack channel so responders…
Spin up a war-room on demand from a Slack slash command
When an engineer runs a Slack command, this workflow creates a Zoom bridge, opens a tracking Sentry-linked incident, files a Linear issue for follow-up.
Run it inside a business
This workflow drops into a full company template. Import the org, and this is one of the playbooks its agents run.
Run this workflow in your colony.
14-day trial. No DevOps. No Sales call. Provisioned in under a minute.