DEVOPS
Block expensive BigQuery queries on PR open with a dry-run cost comment
On every PR open or sync, dry-runs changed queries against BigQuery and posts a pass/fail cost comment, blocking merge when any query exceeds the budget.
How it runs
The automated pipeline, trigger to output.
- TriggerGitHub PR opened or synchronizedGitHub
- ActionFetch changed .sql files from the PRGitHub
- ActionDry-run each query in BigQueryBigQuery
- LogicEvaluate pass/fail against byte budget
- OutputPost blocking status check commentGitHub
What it does
This is a pre-merge gate. When a pull request opens or gets new commits, it dry-runs each changed query against BigQuery, then writes a single GitHub check comment summarizing estimated bytes and cost per query. If any query is over budget, the comment fails the check so the PR cannot merge until it is fixed.
When to use it
Use it when you want to stop costly queries before they reach the main branch rather than filing cleanup tasks after the fact. It gives authors immediate, inline feedback while the change is still in review.
How it works
- 1A GitHub pull request opened or synchronized event triggers the flow.
- 2The flow fetches changed .sql files from the PR.
- 3Each query runs as a BigQuery dry run for an estimated-bytes figure.
- 4A logic step marks the PR pass or fail against the byte budget.
- 5A status check comment is posted back to the PR with per-query costs and an overall verdict that blocks merge on failure.
Set it up
What you configure once, before turning it on.
- 1Connect GitHubRepos, issues, pull requests, actions.
- 2Connect BigQueryDatasets, queries, schemas.
- 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.