DEVOPS

Daily AWS cost-spike digest from the Cost and Usage Report

Each morning this workflow scans yesterday's AWS Cost and Usage Report in BigQuery for per-service spend spikes versus a trailing baseline.

CategoryDevOps
Enginesim
Difficultyintermediate
Triggerschedule
Steps5
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerDaily schedule after CUR partition loads
  • ActionQuery per-service spend deltas vs trailing baselineGoogle BigQueryBigQuery
  • LogicKeep lines over percent and dollar floors
  • LogicMap each spike to its owning team via tags
  • OutputPost ranked spend-spike digest to SlackSlack

What it does

Runs a scheduled sweep over the AWS Cost and Usage Report (CUR) loaded into BigQuery. For each service-and-account line, it compares yesterday's spend to a trailing 14-day median, flags statistically meaningful jumps, maps each to its owning team via a tag lookup, and ships a single ranked digest.

When to use it

Use it when you want a proactive daily pulse on cloud spend instead of reacting to pages. Ideal for FinOps or platform teams who already export CUR into BigQuery and tag resources by team.

How it works

  1. 1A daily schedule fires after the previous day's CUR partition has loaded.
  2. 2A BigQuery query computes per-service spend deltas against the trailing baseline.
  3. 3A logic step keeps only lines exceeding both a percentage and absolute-dollar floor.
  4. 4Each flagged line is joined to an owning-team mapping pulled from cost-allocation tags.
  5. 5The digest is sorted by dollar impact, biggest first.
  6. 6The ranked digest posts to the FinOps Slack channel with per-team callouts.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect BigQueryDatasets, queries, schemas.
  2. 2
    Connect SlackChannels, DMs, threads, mentions.
  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.