DEVOPS

Attribute daily cloud-spend spikes to the owning team and file a Linear ticket

Each morning it scans yesterday's BigQuery billing export for cost spikes per service, maps the offending service to its owning team via a label lookup.

CategoryDevOps
Enginesim
Difficultyintermediate
Triggerschedule
Steps5
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerDaily schedule after billing export loads
  • ActionQuery per-service spend vs 14-day baselineGoogle BigQueryBigQuery
  • LogicKeep spikes above % and $ thresholds
  • ActionLook up owning team for each flagged serviceGoogle BigQueryBigQuery
  • OutputFile Linear ticket assigned to owning teamLinearLinear

What it does

Runs a scheduled scan of your GCP/cloud billing export in BigQuery, finds services whose spend jumped sharply versus their trailing baseline, attributes each spike to the team that owns the service, and files a Linear ticket so the cost has a clear owner instead of disappearing into the monthly bill.

When to use it

Use it when cloud cost overruns keep getting noticed too late and nobody is sure which team caused them. Best for orgs with a BigQuery billing export and per-service ownership labels (cost-center or team tags).

How it works

  1. 1A daily schedule fires after the billing export lands.
  2. 2A BigQuery query computes per-service cost for yesterday and the trailing 14-day daily average.
  3. 3A logic step keeps only services where yesterday exceeded the baseline by both a percentage and an absolute-dollar floor (filters out noisy tiny services).
  4. 4A second BigQuery lookup joins each flagged service to its owning team from the ownership/labels table.
  5. 5For each attributed spike, a Linear ticket is created, assigned to the owning team, with the delta, baseline, and top contributing SKU in the body.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect BigQueryDatasets, queries, schemas.
  2. 2
    Connect LinearIssues, projects, cycles, triage.
  3. 3
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  4. 4
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  5. 5
    Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.

Run this workflow in your colony.

14-day trial. No DevOps. No Sales call. Provisioned in under a minute.