PagerDuty + Bruin

Source

Ingest PagerDuty data into your warehouse with incremental loading, quality checks, and full lineage. Defined in YAML, version-controlled in Git.

For business teams

What you get

Engineering metrics in business terms
Join PagerDuty data with revenue and customer data. Show leadership how engineering reliability impacts the bottom line.
DORA metrics, automated
PagerDuty data feeds deployment frequency, lead time, MTTR, and change failure rate calculations automatically.
Catch data gaps
Quality checks ensure PagerDuty data is complete and fresh. Stale metrics mean bad decisions, Bruin catches it.
Cross-tool visibility
Combine PagerDuty with Jira, GitHub, PagerDuty, and other tools. See the full engineering picture in one place.

For data & engineering teams

How it works

Freshness checks built in
Quality checks ensure PagerDuty data is recent. Stale engineering metrics mean bad decisions, Bruin catches it.
YAML-defined, Git-versioned
Your PagerDuty pipeline is a YAML file. Review in PRs, deploy with CI/CD, roll back with git revert.
SQL + Python transforms
Calculate DORA metrics, MTTR, and custom KPIs with SQL or Python, in the same pipeline as ingestion.
Multi-source pipelines
Combine PagerDuty with Jira, GitHub, PagerDuty in one pipeline. Bruin resolves cross-source dependencies.

Before you start

PagerDuty account

API key with read-only access

Admin or Global Admin role

Step 1

Add your PagerDuty connection

Connect using PagerDuty REST API key. Add this to your Bruin environment file, credentials are stored securely and referenced by name in your pipeline YAML.

Parameters

api_keyPagerDuty REST API key (v2)

connections:
  pagerduty:
    type: pagerduty
    uri: "pagerduty://api_key"

Step 2

Create your pipeline

Define a YAML asset that tells Bruin what to pull from PagerDuty and where to land it. This file lives in your Git repo, reviewable, version-controlled, and deployable with CI/CD.

Available tables

incidentsservicesusersschedulesescalation_policiesanalytics

name: raw.pagerduty_incidents
type: ingestr

parameters:
  source_connection: pagerduty
  source_table: 'incidents'
  destination: bigquery

Step 3

Add quality checks

Add column-level and custom SQL checks to your PagerDuty data. If a check fails, the pipeline stops, bad data never reaches downstream models or dashboards.

Validate data freshness, stale metrics get flagged

Ensure record IDs are unique across syncs

Catch records older than expected sync window

columns:
  - name: id
    checks:
      - name: not_null
      - name: unique
  - name: created_at
    checks:
      - name: not_null

custom_checks:
  - name: no stale records
    query: |
      SELECT COUNT(*) > 0
      FROM raw.pagerduty_incidents
      WHERE created_at > TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 7 DAY)

Step 4

Run it

One command. Bruin connects to PagerDuty, pulls data incrementally, runs your quality checks, and lands clean data in your warehouse. If a check fails, the pipeline stops, bad data never reaches downstream.

Backfill historical data with --start-date

Schedule with cron or trigger from CI/CD

Full lineage from PagerDuty to your dashboards

$ bruin run .

Running pipeline...

  pagerduty_incidents
    ✓ Fetched 2,847 new records
    ✓ Quality: campaign_id not_null     PASSED
    ✓ Quality: spend not_null           PASSED
    ✓ Quality: no negative ad spend     PASSED
    ✓ Loaded into bigquery

  Completed in 12s

Other Engineering integrations

Asana

Bitbucket

CircleCI

ClickUp

Cursor

Datadog

Ready to connect PagerDuty?

Start for free, or book a demo to see how Bruin handles ingestion, quality, lineage, and scheduling for your entire data stack.

Book a demo Read the docs