DEVOPS

On-Demand DORA Snapshot for a Single Team

Triggered manually with a team and date range, pulls that team's GitLab deploys and lead times, writes the detailed records to Postgres.

CategoryDevOps
Enginesim
Difficultyintermediate
Triggermanual
Steps5
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerManual run with team and date range
  • ActionFetch team pipelines and MRs in the windowGitLabGitLab
  • LogicBuild per-deploy rows and aggregate summary
  • ActionWrite detailed records to PostgresPostgreSQLPostgres
  • OutputAppend snapshot summary to BigQueryGoogle BigQueryBigQuery

What it does

This produces a focused DORA snapshot for one team over any window you specify. It captures both the granular per-deploy records and a rolled-up summary, supporting deep dives like quarterly reviews or post-reorg baselining.

When to use it

Use it when someone asks "how is Team X actually doing" outside the normal weekly cadence — a manager prepping a review, or validating a process change against a specific historical period.

How it works

  1. 1A manual trigger collects the team identifier and a start/end date range.
  2. 2An action queries the GitLab API for that team's pipelines and merged MRs within the window.
  3. 3A compute step builds per-deploy rows (deploy time, lead-time hours, MR id) plus a single aggregate summary of deploy count and median lead time.
  4. 4The detailed rows are written to a Postgres `dora_deploy_events` table for record-level analysis.
  5. 5The output step appends the aggregate summary to the BigQuery scorecard table, tagged as an on-demand snapshot so it does not mix with the scheduled weekly series.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect GitLabRepos, MRs, pipelines, registry.
  2. 2
    Connect PostgresAny Postgres URL — query, write, migrate.
  3. 3
    Connect BigQueryDatasets, queries, schemas.
  4. 4
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  5. 5
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  6. 6
    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.