Referência do conector PagerDuty

info

Beta

Esse recurso está em Beta. Para usá-lo, o administrador do workspace deve ativar o Lakeflow Connect for PagerDuty na página Pré-visualizações . Consulte Gerenciar prévias do Databricks.

Esta página contém informações de referência para o conector gerenciado do PagerDuty, incluindo tabelas de origem suportadas e esquemas de tabela de destino.

Tabelas de origem suportadas

O conector PagerDuty oferece suporte às seguintes tabelas de origem, todas sob o esquema de origem default:

Tabela de origem	Chave primária	Descrição	Modo de sincronização	Campo do cursor
`incidents`	`id`	Incidentes em sua account do PagerDuty, incluindo status, urgência, atribuições, reconhecimentos e prioridade.	Incremental	`created_at`
`log_entries`	`id`	Entradas de log que registram ações realizadas em incidentes, como Trigger, reconhecimentos, escalonamentos e resoluções.	Incremental	`created_at`
`services`	`id`	Serviços monitorados no PagerDuty, incluindo política de escalonamento, agrupamento de alertas e horário de suporte.	Apenas refresh completo
`users`	`id`	Usuários em sua account PagerDuty, incluindo função, métodos de contato, regras de notificação e participação na equipe.	Apenas refresh completo
`teams`	`id`	Equipes em sua account do PagerDuty, incluindo nome, descrição e função default.	Apenas refresh completo
`priorities`	`id`	Níveis de prioridade definidos para sua account do PagerDuty.	Apenas refresh completo
`escalation_policies`	`id`	Políticas de escalonamento, incluindo regras de escalonamento, destinos e serviços e equipes associados.	Apenas refresh completo
`schedules`	`id`	Programações de plantão, incluindo usuários atribuídos, equipes e políticas de escalonamento.	Apenas refresh completo
`oncalls`	`escalation_policy_id`, `user_id`, `schedule_id`, `escalation_level`, `start`	Atribuições de plantão atuais e agendadas, mapeando usuários para políticas de escalonamento e programações.	Apenas refresh completo
`audit_records`	`lw_id`	Registros de trilha de auditoria de ações realizadas em sua account PagerDuty, incluindo o ator, o método e o recurso afetado.	Incremental	`execution_time`

Tabela de origem	Chave primária	Descrição	Modo de sincronização	Campo do cursor
`incidents`	`id`	Incidentes em sua account do PagerDuty, incluindo status, urgência, atribuições, reconhecimentos e prioridade.	Incremental	`created_at`
`log_entries`	`id`	Entradas de log que registram ações realizadas em incidentes, como Trigger, reconhecimentos, escalonamentos e resoluções.	Incremental	`created_at`
`services`	`id`	Serviços monitorados no PagerDuty, incluindo política de escalonamento, agrupamento de alertas e horário de suporte.	Apenas refresh completo
`users`	`id`	Usuários em sua account PagerDuty, incluindo função, métodos de contato, regras de notificação e participação na equipe.	Apenas refresh completo
`teams`	`id`	Equipes em sua account do PagerDuty, incluindo nome, descrição e função default.	Apenas refresh completo
`priorities`	`id`	Níveis de prioridade definidos para sua account do PagerDuty.	Apenas refresh completo
`escalation_policies`	`id`	Políticas de escalonamento, incluindo regras de escalonamento, destinos e serviços e equipes associados.	Apenas refresh completo
`schedules`	`id`	Programações de plantão, incluindo usuários atribuídos, equipes e políticas de escalonamento.	Apenas refresh completo
`oncalls`	`escalation_policy_id`, `user_id`, `schedule_id`, `escalation_level`, `start`	Atribuições de plantão atuais e agendadas, mapeando usuários para políticas de escalonamento e programações.	Apenas refresh completo
`audit_records`	`lw_id`	Registros de trilha de auditoria de ações realizadas em sua account PagerDuty, incluindo o ator, o método e o recurso afetado.	Incremental	`execution_time`

A tabela de destino audit_records é liquid clustered na coluna time para queries eficientes de intervalo de tempo.

Opções do conector

O conector do PagerDuty não possui opções de configuração adicionais além das configurações de pipeline disponíveis para todos os conectores gerenciados. Consulte Ingerir dados do PagerDuty.

Esquemas de tabela de destino

`incidents`

Primária key: id Campo de cursor: created_at

campo	Tipo de dados
`id`	`STRING`
`incident_number`	`BIGINT`
`title`	`STRING`
`description`	`STRING`
`created_at`	`TIMESTAMP`
`updated_at`	`TIMESTAMP`
`status`	`STRING`
`incident_key`	`STRING`
`urgency`	`STRING`
`html_url`	`STRING`
`summary`	`STRING`
`type`	`STRING`
`self`	`STRING`
`service`	`STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>`
`assignments`	`ARRAY<STRUCT<at: TIMESTAMP, assignee: STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>>>`
`assigned_via`	`STRING`
`acknowledgements`	`ARRAY<STRUCT<at: TIMESTAMP, acknowledger: STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>>>`
`last_status_change_at`	`TIMESTAMP`
`last_status_change_by`	`STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>`
`first_trigger_log_entry`	`STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>`
`escalation_policy`	`STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>`
`teams`	`ARRAY<STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>>`
`priority`	`STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING, name: STRING, color: STRING, description: STRING, order: BIGINT>`
`resolve_reason`	`STRUCT<type: STRING, incident: STRUCT<id: STRING, type: STRING, summary: STRING>>`
`alert_counts`	`STRUCT<all: BIGINT, triggered: BIGINT, resolved: BIGINT>`
`conference_bridge`	`STRUCT<conference_number: STRING, conference_url: STRING>`
`incidents_responders`	`ARRAY<STRUCT<state: STRING, user: STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>, incident: STRUCT<id: STRING, type: STRING, summary: STRING>, updated_at: TIMESTAMP, message: STRING, requester: STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>, requested_at: TIMESTAMP>>`
`responder_requests`	`ARRAY<STRUCT<requester: STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>, requested_at: TIMESTAMP, message: STRING, responder_request_targets: ARRAY<STRUCT<responder_request_target: STRUCT<id: STRING, type: STRING, summary: STRING, incidents_responders: ARRAY<STRING>>>>>>`
`subscriber_requests`	`ARRAY<STRUCT<subscriber: STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>, subscribable: STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>, account: STRUCT<id: STRING, type: STRING>, requester: STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>, requester_type: STRING, has_indirect_subscription: BOOLEAN, subscriber_type: STRING, created_at: TIMESTAMP>>`
`urgent_subscriber_count`	`BIGINT`
`is_mergeable`	`BOOLEAN`
`body`	`STRUCT<type: STRING, details: STRING>`
`custom_fields`	`ARRAY<STRUCT<id: STRING, name: STRING, type: STRING, data_type: STRING, field_type: STRING, description: STRING, display_name: STRING, value: STRING>>`
`external_references`	`ARRAY<STRUCT<id: STRING, type: STRING, external_id: STRING, external_url: STRING, sync_state: STRING, synced_via: STRING>>`
`resolved_at`	`TIMESTAMP`
`incident_type`	`STRUCT<name: STRING>`
`alert_grouping`	`STRING`
`basic_alert_grouping`	`STRING`
`pending_actions`	`ARRAY<STRUCT<type: STRING, at: TIMESTAMP>>`

campo	Tipo de dados
`id`	`STRING`
`incident_number`	`BIGINT`
`title`	`STRING`
`description`	`STRING`
`created_at`	`TIMESTAMP`
`updated_at`	`TIMESTAMP`
`status`	`STRING`
`incident_key`	`STRING`
`urgency`	`STRING`
`html_url`	`STRING`
`summary`	`STRING`
`type`	`STRING`
`self`	`STRING`
`service`	`STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>`
`assignments`	`ARRAY<STRUCT<at: TIMESTAMP, assignee: STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>>>`
`assigned_via`	`STRING`
`acknowledgements`	`ARRAY<STRUCT<at: TIMESTAMP, acknowledger: STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>>>`
`last_status_change_at`	`TIMESTAMP`
`last_status_change_by`	`STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>`
`first_trigger_log_entry`	`STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>`
`escalation_policy`	`STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>`
`teams`	`ARRAY<STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>>`
`priority`	`STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING, name: STRING, color: STRING, description: STRING, order: BIGINT>`
`resolve_reason`	`STRUCT<type: STRING, incident: STRUCT<id: STRING, type: STRING, summary: STRING>>`
`alert_counts`	`STRUCT<all: BIGINT, triggered: BIGINT, resolved: BIGINT>`
`conference_bridge`	`STRUCT<conference_number: STRING, conference_url: STRING>`
`incidents_responders`	`ARRAY<STRUCT<state: STRING, user: STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>, incident: STRUCT<id: STRING, type: STRING, summary: STRING>, updated_at: TIMESTAMP, message: STRING, requester: STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>, requested_at: TIMESTAMP>>`
`responder_requests`	`ARRAY<STRUCT<requester: STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>, requested_at: TIMESTAMP, message: STRING, responder_request_targets: ARRAY<STRUCT<responder_request_target: STRUCT<id: STRING, type: STRING, summary: STRING, incidents_responders: ARRAY<STRING>>>>>>`
`subscriber_requests`	`ARRAY<STRUCT<subscriber: STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>, subscribable: STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>, account: STRUCT<id: STRING, type: STRING>, requester: STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>, requester_type: STRING, has_indirect_subscription: BOOLEAN, subscriber_type: STRING, created_at: TIMESTAMP>>`
`urgent_subscriber_count`	`BIGINT`
`is_mergeable`	`BOOLEAN`
`body`	`STRUCT<type: STRING, details: STRING>`
`custom_fields`	`ARRAY<STRUCT<id: STRING, name: STRING, type: STRING, data_type: STRING, field_type: STRING, description: STRING, display_name: STRING, value: STRING>>`
`external_references`	`ARRAY<STRUCT<id: STRING, type: STRING, external_id: STRING, external_url: STRING, sync_state: STRING, synced_via: STRING>>`
`resolved_at`	`TIMESTAMP`
`incident_type`	`STRUCT<name: STRING>`
`alert_grouping`	`STRING`
`basic_alert_grouping`	`STRING`
`pending_actions`	`ARRAY<STRUCT<type: STRING, at: TIMESTAMP>>`

nota

A tabela incidents captura apenas inserções. O PagerDuty filtra esta tabela por created_at, portanto, atualizações e exclusões de incidentes exigem um refresh completo periódico. Consulte limitações do conector PagerDuty.

`log_entries`

Primária key: id Campo de cursor: created_at

campo	Tipo de dados
`id`	`STRING`
`type`	`STRING`
`summary`	`STRING`
`self`	`STRING`
`html_url`	`STRING`
`created_at`	`TIMESTAMP`
`note`	`STRING`
`agent`	`STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>`
`channel`	`STRUCT<type: STRING, raw_event: STRING, details: STRING, cef_details: STRING>`
`service`	`STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>`
`incident`	`STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>`
`teams`	`ARRAY<STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>>`
`contexts`	`ARRAY<STRUCT<type: STRING, href: STRING, text: STRING>>`
`event_details`	`STRUCT<description: STRING>`
`assignees`	`ARRAY<STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>>`

campo	Tipo de dados
`id`	`STRING`
`type`	`STRING`
`summary`	`STRING`
`self`	`STRING`
`html_url`	`STRING`
`created_at`	`TIMESTAMP`
`note`	`STRING`
`agent`	`STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>`
`channel`	`STRUCT<type: STRING, raw_event: STRING, details: STRING, cef_details: STRING>`
`service`	`STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>`
`incident`	`STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>`
`teams`	`ARRAY<STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>>`
`contexts`	`ARRAY<STRUCT<type: STRING, href: STRING, text: STRING>>`
`event_details`	`STRUCT<description: STRING>`
`assignees`	`ARRAY<STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>>`

`services`

Chave key: id Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
`id`	`STRING`
`type`	`STRING`
`summary`	`STRING`
`self`	`STRING`
`html_url`	`STRING`
`name`	`STRING`
`description`	`STRING`
`auto_resolve_timeout`	`BIGINT`
`acknowledgement_timeout`	`BIGINT`
`created_at`	`TIMESTAMP`
`updated_at`	`TIMESTAMP`
`status`	`STRING`
`last_incident_timestamp`	`TIMESTAMP`
`escalation_policy`	`STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>`
`teams`	`ARRAY<STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>>`
`incident_urgency_rule`	`STRUCT<type: STRING, urgency: STRING, during_support_hours: STRUCT<type: STRING, urgency: STRING>, outside_support_hours: STRUCT<type: STRING, urgency: STRING>>`
`support_hours`	`STRUCT<type: STRING, time_zone: STRING, start_time: STRING, end_time: STRING, days_of_week: ARRAY<INT>>`
`scheduled_actions`	`ARRAY<STRUCT<type: STRING, at: STRUCT<type: STRING, name: STRING>, to_urgency: STRING>>`
`addons`	`ARRAY<STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>>`
`alert_creation`	`STRING`
`alert_grouping`	`STRING`
`alert_grouping_parameters`	`STRUCT<type: STRING, config: STRUCT<timeout: BIGINT, aggregate: STRING, fields: ARRAY<STRING>, time_window: BIGINT, recommended_time_window: BIGINT>>`
`alert_grouping_timeout`	`BIGINT`
`auto_pause_notifications_parameters`	`STRUCT<enabled: BOOLEAN, timeout: BIGINT>`
`response_play`	`STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>`
`integrations`	`ARRAY<STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>>`

campo	Tipo de dados
`id`	`STRING`
`type`	`STRING`
`summary`	`STRING`
`self`	`STRING`
`html_url`	`STRING`
`name`	`STRING`
`description`	`STRING`
`auto_resolve_timeout`	`BIGINT`
`acknowledgement_timeout`	`BIGINT`
`created_at`	`TIMESTAMP`
`updated_at`	`TIMESTAMP`
`status`	`STRING`
`last_incident_timestamp`	`TIMESTAMP`
`escalation_policy`	`STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>`
`teams`	`ARRAY<STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>>`
`incident_urgency_rule`	`STRUCT<type: STRING, urgency: STRING, during_support_hours: STRUCT<type: STRING, urgency: STRING>, outside_support_hours: STRUCT<type: STRING, urgency: STRING>>`
`support_hours`	`STRUCT<type: STRING, time_zone: STRING, start_time: STRING, end_time: STRING, days_of_week: ARRAY<INT>>`
`scheduled_actions`	`ARRAY<STRUCT<type: STRING, at: STRUCT<type: STRING, name: STRING>, to_urgency: STRING>>`
`addons`	`ARRAY<STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>>`
`alert_creation`	`STRING`
`alert_grouping`	`STRING`
`alert_grouping_parameters`	`STRUCT<type: STRING, config: STRUCT<timeout: BIGINT, aggregate: STRING, fields: ARRAY<STRING>, time_window: BIGINT, recommended_time_window: BIGINT>>`
`alert_grouping_timeout`	`BIGINT`
`auto_pause_notifications_parameters`	`STRUCT<enabled: BOOLEAN, timeout: BIGINT>`
`response_play`	`STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>`
`integrations`	`ARRAY<STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>>`

`users`

Chave key: id Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
`id`	`STRING`
`type`	`STRING`
`summary`	`STRING`
`self`	`STRING`
`html_url`	`STRING`
`name`	`STRING`
`email`	`STRING`
`time_zone`	`STRING`
`color`	`STRING`
`avatar_url`	`STRING`
`billed`	`BOOLEAN`
`role`	`STRING`
`description`	`STRING`
`invitation_sent`	`BOOLEAN`
`job_title`	`STRING`
`locale`	`STRING`
`created_via_sso`	`BOOLEAN`
`teams`	`ARRAY<STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>>`
`contact_methods`	`ARRAY<STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>>`
`notification_rules`	`ARRAY<STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>>`
`coordinated_incidents`	`ARRAY<STRUCT<incident_id: STRING>>`
`license`	`STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING, name: STRING, description: STRING, current_value: INT, allocations_available: INT, role_group: STRING, valid_roles: ARRAY<STRING>>`

campo	Tipo de dados
`id`	`STRING`
`type`	`STRING`
`summary`	`STRING`
`self`	`STRING`
`html_url`	`STRING`
`name`	`STRING`
`email`	`STRING`
`time_zone`	`STRING`
`color`	`STRING`
`avatar_url`	`STRING`
`billed`	`BOOLEAN`
`role`	`STRING`
`description`	`STRING`
`invitation_sent`	`BOOLEAN`
`job_title`	`STRING`
`locale`	`STRING`
`created_via_sso`	`BOOLEAN`
`teams`	`ARRAY<STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>>`
`contact_methods`	`ARRAY<STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>>`
`notification_rules`	`ARRAY<STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>>`
`coordinated_incidents`	`ARRAY<STRUCT<incident_id: STRING>>`
`license`	`STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING, name: STRING, description: STRING, current_value: INT, allocations_available: INT, role_group: STRING, valid_roles: ARRAY<STRING>>`

`teams`

Chave key: id Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
`id`	`STRING`
`type`	`STRING`
`summary`	`STRING`
`self`	`STRING`
`html_url`	`STRING`
`name`	`STRING`
`description`	`STRING`
`default_role`	`STRING`
`parent`	`STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>`

campo	Tipo de dados
`id`	`STRING`
`type`	`STRING`
`summary`	`STRING`
`self`	`STRING`
`html_url`	`STRING`
`name`	`STRING`
`description`	`STRING`
`default_role`	`STRING`
`parent`	`STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>`

`priorities`

Chave key: id Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
`id`	`STRING`
`type`	`STRING`
`summary`	`STRING`
`self`	`STRING`
`html_url`	`STRING`
`name`	`STRING`
`description`	`STRING`
`color`	`STRING`
`account_id`	`STRING`
`order`	`BIGINT`
`schema_version`	`INT`
`created_at`	`TIMESTAMP`
`updated_at`	`TIMESTAMP`

`escalation_policies`

Chave key: id Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
`id`	`STRING`
`type`	`STRING`
`summary`	`STRING`
`self`	`STRING`
`html_url`	`STRING`
`name`	`STRING`
`description`	`STRING`
`num_loops`	`INT`
`on_call_handoff_notifications`	`STRING`
`send_ochons_through_level`	`INT`
`created_at`	`TIMESTAMP`
`updated_at`	`TIMESTAMP`
`escalation_rules`	`ARRAY<STRUCT<id: STRING, escalation_delay_in_minutes: INT, escalation_rule_assignment_strategy: STRING, targets: ARRAY<STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>>>>`
`services`	`ARRAY<STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>>`
`teams`	`ARRAY<STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>>`
`privilege`	`STRUCT<permissions: ARRAY<STRING>>`

campo	Tipo de dados
`id`	`STRING`
`type`	`STRING`
`summary`	`STRING`
`self`	`STRING`
`html_url`	`STRING`
`name`	`STRING`
`description`	`STRING`
`num_loops`	`INT`
`on_call_handoff_notifications`	`STRING`
`send_ochons_through_level`	`INT`
`created_at`	`TIMESTAMP`
`updated_at`	`TIMESTAMP`
`escalation_rules`	`ARRAY<STRUCT<id: STRING, escalation_delay_in_minutes: INT, escalation_rule_assignment_strategy: STRING, targets: ARRAY<STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>>>>`
`services`	`ARRAY<STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>>`
`teams`	`ARRAY<STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>>`
`privilege`	`STRUCT<permissions: ARRAY<STRING>>`

`schedules`

Chave key: id Modo de sincronização: Apenas refresh completo

campo	Tipo de dados
`id`	`STRING`
`type`	`STRING`
`summary`	`STRING`
`self`	`STRING`
`html_url`	`STRING`
`name`	`STRING`
`description`	`STRING`
`time_zone`	`STRING`
`users`	`ARRAY<STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>>`
`teams`	`ARRAY<STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>>`
`escalation_policies`	`ARRAY<STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>>`

campo	Tipo de dados
`id`	`STRING`
`type`	`STRING`
`summary`	`STRING`
`self`	`STRING`
`html_url`	`STRING`
`name`	`STRING`
`description`	`STRING`
`time_zone`	`STRING`
`users`	`ARRAY<STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>>`
`teams`	`ARRAY<STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>>`
`escalation_policies`	`ARRAY<STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>>`

`oncalls`

Primary key: escalation_policy_id, user_id, schedule_id, escalation_level, start Sync mode: Apenas refresh completo

campo	Tipo de dados
`escalation_policy_id`	`STRING`
`user_id`	`STRING`
`schedule_id`	`STRING`
`escalation_level`	`INT`
`start`	`TIMESTAMP`
`end`	`TIMESTAMP`
`escalation_policy`	`STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>`
`user`	`STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>`
`schedule`	`STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>`

campo	Tipo de dados
`escalation_policy_id`	`STRING`
`user_id`	`STRING`
`schedule_id`	`STRING`
`escalation_level`	`INT`
`start`	`TIMESTAMP`
`end`	`TIMESTAMP`
`escalation_policy`	`STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>`
`user`	`STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>`
`schedule`	`STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>`

`audit_records`

Primária key: lw_id Campo de cursor: execution_time

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`id`	`STRING`
`self`	`STRING`
`execution_time`	`TIMESTAMP`
`execution_context`	`STRUCT<request_id: STRING, remote_address: STRING>`
`actors`	`ARRAY<STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>>`
`method`	`STRUCT<description: STRING, type: STRING, truncated_token: STRING>`
`root_resource`	`STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>`
`action`	`STRING`
`details`	`STRUCT<resource: STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>, fields: ARRAY<STRUCT<name: STRING, description: STRING, value: STRING, before_value: STRING>>, references: ARRAY<STRUCT<name: STRING, description: STRING, added: ARRAY<STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>>, removed: ARRAY<STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>>>>>`

campo	Tipo de dados
`lw_id`	`STRING`
`time`	`TIMESTAMP`
`id`	`STRING`
`self`	`STRING`
`execution_time`	`TIMESTAMP`
`execution_context`	`STRUCT<request_id: STRING, remote_address: STRING>`
`actors`	`ARRAY<STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>>`
`method`	`STRUCT<description: STRING, type: STRING, truncated_token: STRING>`
`root_resource`	`STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>`
`action`	`STRING`
`details`	`STRUCT<resource: STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>, fields: ARRAY<STRUCT<name: STRING, description: STRING, value: STRING, before_value: STRING>>, references: ARRAY<STRUCT<name: STRING, description: STRING, added: ARRAY<STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>>, removed: ARRAY<STRUCT<id: STRING, type: STRING, summary: STRING, self: STRING, html_url: STRING>>>>>`

Permissões OAuth necessárias

O aplicativo OAuth do PagerDuty deve conceder os seguintes escopos de leitura. O conjunto de escopos que o conector requer depende de quais tabelas você ingere. Para obter mais informações, consulte a referência de escopos OAuth do PagerDuty.

Permissão	Obrigatório para
`incidents.read`	`incidents`, `log_entries`
`services.read`	`services`
`users.read`	`users`
`teams.read`	`teams`
`priorities.read`	`priorities`
`escalation_policies.read`	`escalation_policies`
`schedules.read`	`schedules`
`oncalls.read`	`oncalls`
`audit_records.read`	`audit_records`
`custom_fields.read`	`incidents`
`subscribers.read`	`incidents`

Permissão	Obrigatório para
`incidents.read`	`incidents`, `log_entries`
`services.read`	`services`
`users.read`	`users`
`teams.read`	`teams`
`priorities.read`	`priorities`
`escalation_policies.read`	`escalation_policies`
`schedules.read`	`schedules`
`oncalls.read`	`oncalls`
`audit_records.read`	`audit_records`
`custom_fields.read`	`incidents`
`subscribers.read`	`incidents`

Tabelas de origem suportadas​

Opções do conector​

Esquemas de tabela de destino​

incidents​

log_entries​

services​

users​

teams​

priorities​

escalation_policies​

schedules​

oncalls​

audit_records​

Permissões OAuth necessárias​

Tabelas de origem suportadas

Opções do conector

Esquemas de tabela de destino

`incidents`

`log_entries`

`services`

`users`

`teams`

`priorities`

`escalation_policies`

`schedules`

`oncalls`

`audit_records`

Permissões OAuth necessárias