DATA OPS

Agent that triages BigQuery schema changes and files fix tickets in Linear

An agent investigates each BigQuery schema change end to end — reading lineage and query logs.

CategoryData Ops
Enginepaperclip
Difficultyadvanced
Triggerwebhook
Steps5
Setup~25 min

How it runs

The automated pipeline, trigger to output.

  • TriggerSchema-change webhookHTTP webhook
  • ActionRead column diff and dbt lineage from GitLabGitLabGitLab
  • ActionPull recent query usage from AxiomAxiom
  • LogicAgent classifies severity and drafts remediation plan
  • OutputOpen scoped, owner-assigned Linear ticketLinearLinear

What it does

Goes beyond listing affected models. When a BigQuery table's schema changes, an agent gathers the evidence — the column diff, the dbt models that reference it from GitLab, and recent query usage from Axiom — and reasons about real impact: which models will actually break, which are cosmetic, and what the fix likely is. It then drafts a Linear ticket with a clear remediation summary and assigns it to the owner.

When to use it

Use it when a raw blast-radius list still leaves a human to interpret severity and write up the fix. The agent does that judgment work, so your data team gets actionable, pre-scoped tickets instead of another alert to triage by hand.

How it works

  1. 1A webhook fires when a schema change is detected on a tracked BigQuery table.
  2. 2The agent reads the column diff and queries dbt lineage from GitLab.
  3. 3It pulls recent query usage from Axiom to gauge whether anything live depends on the change.
  4. 4It reasons over the evidence to classify severity and draft a remediation plan.
  5. 5It opens a scoped Linear ticket assigned to the resolved owner with the assessment attached.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect BigQueryDatasets, queries, schemas.
  2. 2
    Connect GitLabRepos, MRs, pipelines, registry.
  3. 3
    Connect AxiomLog streams, queries, dashboards.
  4. 4
    Connect LinearIssues, projects, cycles, triage.
  5. 5
    Connect HTTP webhookTrigger any URL on agent actions.
  6. 6
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  7. 7
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  8. 8
    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.