Skip to content
Book a demoStart free
Connectors

PagerDuty connector

Set up the PagerDuty connector in Kaivo: authentication, configuration, the 6 BigQuery tables it syncs, and answers to common questions.

PagerDuty connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your PagerDuty data into a Google BigQuery warehouse and keeps it up to date automatically. There is no pipeline to build and no infrastructure to run, so you can spend your time analysing your data from PagerDuty instead of moving it.

Sync your PagerDuty incident data into BigQuery with Kaivo to analyse on-call load, incident trends, and service reliability over time.

CategoryTech
AuthenticationAPI key
SetupSelf-service

Getting started with the PagerDuty connector

Section titled “Getting started with the PagerDuty connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your PagerDuty account.
  3. Choose which tables to sync.
  4. Wait for the initial sync to finish.
  5. Query your data in BigQuery or your favourite AI or BI tool.

Authenticate with your API Key.

Field Description
API Key
PagerDuty API key for authentication.

|

Kaivo syncs 6 tables from PagerDuty into a dedicated dataset in your BigQuery warehouse. Click any table to see its columns and types.

incident_logs (68 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
action STRING
agent__type STRING
agent__html_url STRING
agent__id STRING
agent__self STRING
agent__summary STRING
channel__type STRING
channel__new_priority__type STRING
channel__new_priority__description STRING
channel__new_priority__account_id STRING
channel__new_priority__color STRING
channel__new_priority__created_at STRING
channel__new_priority__html_url STRING
channel__new_priority__id STRING
channel__new_priority__name STRING
channel__new_priority__order FLOAT64
channel__new_priority__schema_version FLOAT64
channel__new_priority__self STRING
channel__new_priority__summary STRING
channel__new_priority__updated_at STRING
channel__notification__type STRING
channel__notification__address STRING
channel__notification__conference_address STRING
channel__notification__status STRING
channel__old_priority STRING
channel__summary STRING
channels STRING
created_at STRING
escalation_policy__type STRING
escalation_policy__description STRING
escalation_policy__html_url STRING
escalation_policy__id STRING
escalation_policy__name STRING
escalation_policy__num_loops FLOAT64
escalation_policy__on_call_handoff_notifications STRING
escalation_policy__privilege STRING
escalation_policy__self STRING
escalation_policy__summary STRING
event_details__description STRING
html_url STRING
id STRING
incident__type STRING
incident__html_url STRING
incident__id STRING
incident__self STRING
incident__summary STRING
level FLOAT64
message STRING
responder__type STRING
responder__html_url STRING
responder__id STRING
responder__self STRING
responder__summary STRING
self STRING
service__type STRING
service__html_url STRING
service__id STRING
service__self STRING
service__summary STRING
summary STRING
user__type STRING
user__html_url STRING
user__id STRING
user__self STRING
user__summary STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
html_url STRING
id STRING
self STRING
summary STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: incident_logs__escalation_policy__escalation_rules

Section titled “Subtable: incident_logs__escalation_policy__escalation_rules”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
escalation_delay_in_minutes FLOAT64
id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: incident_logs__escalation_policy__escalation_rules__targets

Section titled “Subtable: incident_logs__escalation_policy__escalation_rules__targets”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
html_url STRING
id STRING
self STRING
summary STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: incident_logs__escalation_policy__services

Section titled “Subtable: incident_logs__escalation_policy__services”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
html_url STRING
id STRING
self STRING
summary STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: incident_logs__escalation_policy__teams

Section titled “Subtable: incident_logs__escalation_policy__teams”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
html_url STRING
id STRING
self STRING
summary STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
incidents (57 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
description STRING
alert_counts__all FLOAT64
alert_counts__resolved FLOAT64
alert_counts__triggered FLOAT64
alert_grouping STRING
assigned_via STRING
basic_alert_grouping STRING
created_at STRING
escalation_policy__type STRING
escalation_policy__html_url STRING
escalation_policy__id STRING
escalation_policy__self STRING
escalation_policy__summary STRING
first_trigger_log_entry__type STRING
first_trigger_log_entry__html_url STRING
first_trigger_log_entry__id STRING
first_trigger_log_entry__self STRING
first_trigger_log_entry__summary STRING
html_url STRING
id STRING
incident_key STRING
incident_number FLOAT64
is_mergeable BOOL
last_status_change_at STRING
last_status_change_by__type STRING
last_status_change_by__html_url STRING
last_status_change_by__id STRING
last_status_change_by__self STRING
last_status_change_by__summary STRING
priority__type STRING
priority__description STRING
priority__account_id STRING
priority__color STRING
priority__created_at STRING
priority__html_url STRING
priority__id STRING
priority__name STRING
priority__order FLOAT64
priority__schema_version FLOAT64
priority__self STRING
priority__summary STRING
priority__updated_at STRING
resolved_at STRING
self STRING
service__type STRING
service__html_url STRING
service__id STRING
service__self STRING
service__summary STRING
status STRING
summary STRING
title STRING
updated_at STRING
urgency STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
acknowledger__type STRING
acknowledger__html_url STRING
acknowledger__id STRING
acknowledger__self STRING
acknowledger__summary STRING
at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
assignee__type STRING
assignee__html_url STRING
assignee__id STRING
assignee__self STRING
assignee__summary STRING
at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
incident__type STRING
incident__html_url STRING
incident__id STRING
incident__self STRING
incident__summary STRING
message STRING
requested_at STRING
requester__type STRING
requester__avatar_url STRING
requester__html_url STRING
requester__id STRING
requester__job_title STRING
requester__self STRING
requester__summary STRING
state STRING
updated_at STRING
user__type STRING
user__avatar_url STRING
user__html_url STRING
user__id STRING
user__job_title STRING
user__self STRING
user__summary STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: incidents__incidents_responders__escalation_policy_requests

Section titled “Subtable: incidents__incidents_responders__escalation_policy_requests”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
incident__type STRING
incident__html_url STRING
incident__id STRING
incident__self STRING
incident__summary STRING
message STRING
requested_at STRING
requester__type STRING
requester__html_url STRING
requester__id STRING
requester__self STRING
requester__summary STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: incidents__responder_requests__responder_request_targets

Section titled “Subtable: incidents__responder_requests__responder_request_targets”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
responder_request_target__type STRING
responder_request_target__id STRING
responder_request_target__summary STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: incidents__responder_requests__responder_request_targets__responder_request_target__incidents_responders

Section titled “Subtable: incidents__responder_requests__responder_request_targets__responder_request_target__incidents_responders”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
incident__type STRING
incident__html_url STRING
incident__id STRING
incident__self STRING
incident__summary STRING
message STRING
requested_at STRING
requester__type STRING
requester__avatar_url STRING
requester__html_url STRING
requester__id STRING
requester__job_title STRING
requester__self STRING
requester__summary STRING
state STRING
updated_at STRING
user__type STRING
user__avatar_url STRING
user__html_url STRING
user__id STRING
user__job_title STRING
user__self STRING
user__summary STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
priorities (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
description STRING
account_id STRING
color STRING
created_at STRING
html_url STRING
id STRING
name STRING
order FLOAT64
schema_version FLOAT64
self STRING
summary STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
services (30 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
description STRING
acknowledgement_timeout STRING
alert_creation STRING
alert_grouping STRING
alert_grouping_parameters__type STRING
alert_grouping_parameters__config__recommended_time_window FLOAT64
alert_grouping_parameters__config__time_window FLOAT64
alert_grouping_timeout STRING
auto_resolve_timeout STRING
created_at STRING
escalation_policy__type STRING
escalation_policy__html_url STRING
escalation_policy__id STRING
escalation_policy__self STRING
escalation_policy__summary STRING
html_url STRING
id STRING
incident_urgency_rule__type STRING
incident_urgency_rule__urgency STRING
last_incident_timestamp STRING
name STRING
response_play STRING
self STRING
status STRING
summary STRING
support_hours STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
html_url STRING
id STRING
self STRING
summary STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
teams (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
description STRING
default_role STRING
html_url STRING
id STRING
name STRING
parent STRING
self STRING
summary STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
users (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
description STRING
avatar_url STRING
billed BOOL
color STRING
email STRING
html_url STRING
id STRING
invitation_sent BOOL
job_title STRING
name STRING
role STRING
self STRING
summary STRING
time_zone STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
html_url STRING
id STRING
self STRING
summary STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
incident__type STRING
incident__html_url STRING
incident__id STRING
incident__self STRING
incident__summary STRING
message STRING
requested_at STRING
requester__type STRING
requester__html_url STRING
requester__id STRING
requester__self STRING
requester__summary STRING
state STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
html_url STRING
id STRING
self STRING
summary STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
html_url STRING
id STRING
self STRING
summary STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where PagerDuty supports it, each sync pulls only new and changed records so it stays fast; otherwise it refreshes the whole table. Every record keeps its original ID, so you won’t get duplicate rows.

How long does the initial sync take for PagerDuty?

Section titled “How long does the initial sync take for PagerDuty?”

It depends on how much history is in your PagerDuty account. Most initial syncs finish within minutes, while large accounts can take a few hours. After that, syncs only fetch new and changed records, so they’re much faster.

Yes. You pick which tables to sync when you set up the connection and can change the selection later. Tables you don’t select are never copied to your warehouse.

What happens when PagerDuty’s schema changes?

Section titled “What happens when PagerDuty’s schema changes?”

New fields are never added automatically. You choose which fields to sync, so data you haven’t selected (sensitive personal data, for example) never lands in your warehouse. When a new field appears, it becomes available for you to add. What happens to removed or renamed fields depends on a table’s sync mode: full-refresh tables always match what’s currently in PagerDuty, so dropped fields disappear, while incremental tables keep their existing columns and history, so an old field stays and newly added fields fill in over time.

How do I handle GDPR or data deletion requests?

Section titled “How do I handle GDPR or data deletion requests?”

Your data lives in your own Kaivo-managed BigQuery warehouse, so the most direct option is to delete or anonymise specific records right in BigQuery. If you delete data in PagerDuty instead, full-refresh tables drop it on the next sync, while incremental tables keep it, so you would remove the row in BigQuery or ask us to run a full refresh. To remove everything, delete the PagerDuty connector in Kaivo and all of its synced data is deleted with it.

Use incidents and incident_logs to track frequency, severity, and time to resolve.

Join incidents with users and teams to see who carries the most on-call burden.

Group incidents by service to find the systems that page most often.

Use priorities to understand how serious incidents are distributed.

Use PagerDuty data in your AI and BI tools

Section titled “Use PagerDuty data in your AI and BI tools”

Once PagerDuty data lands in your Kaivo-managed BigQuery warehouse, you can explore it with AI tools or any BI tool that connects to BigQuery. Here’s how the most common destinations work with PagerDuty data.

Use Kaivo’s MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →

Microsoft’s BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →

Free Google BI tool with native BigQuery support. One-click connection to your Kaivo warehouse; great for SMB teams on Google Workspace. Setup guide →

The premium analytics standard, with native BigQuery integration. Setup guide →

Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →

Connect via Power Query’s BigQuery connector. Setup guide →

Open-source BI tool with strong BigQuery support. Setup guide →

See our pricing page for PagerDuty connector pricing and plan details.

  • Adform: Sync Adform to BigQuery.
  • Amplitude: Sync Amplitude to BigQuery.
  • Auth0: Sync Auth0 to BigQuery.
  • Convex: Sync Convex to BigQuery.
  • GitHub: Sync GitHub to BigQuery.
  • GitLab: Sync GitLab to BigQuery.