Skip to content
Book a demoStart free
Connectors

FireHydrant connector

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

FireHydrant connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your FireHydrant 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 FireHydrant instead of moving it.

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

CategoryTech
AuthenticationAPI key
SetupSelf-service

Getting started with the FireHydrant connector

Section titled “Getting started with the FireHydrant connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your FireHydrant 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 Token.

Field Description
API Token
Bot token to use for authenticating with the FireHydrant API. You can find or create a bot token by logging into your organization and visiting the Bot users page at https://app.firehydrant.io/organizations/bots.

|

Tables and columns synced from FireHydrant

Section titled “Tables and columns synced from FireHydrant”

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

alerts (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
id STRING
integration_name STRING
is_expired BOOL
position FLOAT64
remote_id STRING
remote_url STRING
signal_id STRING
source_icon STRING
starts_at STRING
status STRING
summary STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • alerts__environments (4 columns)
  • alerts__incidents (7 columns)
  • alerts__services (4 columns)
  • alerts__tags (4 columns)
changes (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
created_at STRING
id STRING
labels__property1 STRING
labels__property2 STRING
summary STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
changes_events (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
created_at STRING
duration_iso8601 STRING
duration_ms FLOAT64
ends_at STRING
id STRING
labels__j STRING
labels__old STRING
starts_at STRING
summary STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • changes_events__authors (7 columns)
  • changes_events__environments (9 columns)
  • changes_events__environments__active_incidents (4 columns)
  • changes_events__environments__external_resources (4 columns)
  • changes_events__services (13 columns)
checklist_templates (18 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
created_at STRING
id STRING
name STRING
owner__description STRING
owner__created_at STRING
owner__created_by__email STRING
owner__created_by__id STRING
owner__created_by__name STRING
owner__created_by__source STRING
owner__id STRING
owner__name STRING
owner__signals_ical_url STRING
owner__slug STRING
owner__updated_at STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • checklist_templates__checks (6 columns)
  • checklist_templates__connected_services (26 columns)
custom_fields_definitions (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
display_name STRING
field_id STRING
field_type STRING
required BOOL
slug STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • custom_fields_definitions__permissible_values (4 columns)
entitlements (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
available BOOL
current_count FLOAT64
exists BOOL
maximum FLOAT64
name STRING
slug STRING
tier STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • entitlements__errors__access (4 columns)
  • entitlements__errors__quota (4 columns)
environments (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
created_at STRING
id STRING
name STRING
slug STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • environments__active_incidents (4 columns)
  • environments__external_resources (4 columns)
functionalities (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
alert_on_add BOOL
created_at STRING
id STRING
name STRING
slug STRING
updated_at STRING
updated_by__email STRING
updated_by__id STRING
updated_by__name STRING
updated_by__source STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • functionalities__active_incidents (4 columns)
  • functionalities__external_resources (4 columns)
  • functionalities__links (4 columns)
  • functionalities__services (4 columns)
  • functionalities__teams (4 columns)
incident_roles (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
created_at STRING
id STRING
name STRING
summary STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
incident_tags (3 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
incident_types (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at STRING
id STRING
name STRING
template__description STRING
template__priority STRING
template__severity STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • incident_types__template__impacts (8 columns)
  • incident_types__template__runbook_ids (4 columns)
  • incident_types__template__tag_list (4 columns)
  • incident_types__template_values__environments (8 columns)
  • incident_types__template_values__functionalities (8 columns)
  • incident_types__template_values__services (4 columns)
incidents (32 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
active BOOL
created_at STRING
created_by__email STRING
created_by__id STRING
created_by__name STRING
created_by__source STRING
current_milestone STRING
customer_impact_summary STRING
customers_impacted FLOAT64
id STRING
incident_url STRING
last_note__body STRING
last_note__created_at STRING
last_note__id STRING
last_update STRING
name STRING
number FLOAT64
organization__id STRING
organization__name STRING
organization_id STRING
priority STRING
private_id STRING
private_status_page_url STRING
report_id STRING
restricted BOOL
severity STRING
severity_color STRING
started_at STRING
summary STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • incidents__conference_bridges (4 columns)
  • incidents__conversations (9 columns)
  • incidents__custom_fields (11 columns)
  • incidents__environments (5 columns)
  • incidents__field_requirements (4 columns)
  • incidents__functionalities (5 columns)
  • incidents__impacts (10 columns)
  • incidents__impacts__conversations (8 columns)
  • incidents__incident_channels (4 columns)
  • incidents__incident_tickets (4 columns)
  • incidents__last_note__conversations (8 columns)
  • incidents__last_note__status_pages (4 columns)
  • incidents__lifecycle_measurements (11 columns)
  • incidents__lifecycle_phases (8 columns)
  • incidents__lifecycle_phases__milestones (15 columns)
  • incidents__milestones (9 columns)
  • incidents__retro_exports (4 columns)
  • incidents__role_assignments (19 columns)
  • incidents__role_assignments__user__signals_enabled_notification_types (4 columns)
  • incidents__services (5 columns)
  • incidents__status_pages (4 columns)
  • incidents__tag_list (4 columns)
  • incidents__team_assignments (4 columns)
infrastructures (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
id STRING
infrastructure__description STRING
infrastructure__alert_on_add BOOL
infrastructure__auto_add_responding_team BOOL
infrastructure__created_at STRING
infrastructure__id STRING
infrastructure__labels__j STRING
infrastructure__name STRING
infrastructure__service_tier FLOAT64
infrastructure__slug STRING
infrastructure__updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • infrastructures__infrastructure__active_incidents (4 columns)
  • infrastructures__infrastructure__external_resources (4 columns)
integrations (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
created_at STRING
deprecated BOOL
enabled BOOL
id STRING
installed BOOL
logo__logo_url STRING
name STRING
nat_ip STRING
setup_url STRING
slug STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • integrations__connections (4 columns)
measurement_definitions (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
created_at STRING
ends_at_milestone__id STRING
ends_at_milestone__name STRING
ends_at_milestone__slug STRING
healthiness BOOL
id STRING
name STRING
slug STRING
starts_at_milestone__id STRING
starts_at_milestone__name STRING
starts_at_milestone__slug STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
nunc_connections (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
cname STRING
company_name STRING
domain STRING
enable_histogram BOOL
greeting_body STRING
greeting_title STRING
id STRING
operational_message STRING
title STRING
ui_version FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • nunc_connections__component_groups (4 columns)
  • nunc_connections__components (4 columns)
  • nunc_connections__conditions (6 columns)
  • nunc_connections__exposed_fields (4 columns)
  • nunc_connections__links (4 columns)
phases (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
description STRING
id STRING
name STRING
position FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • phases__milestones (18 columns)
post_mortems_questions (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING
is_required BOOL
kind STRING
title STRING
tooltip STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
post_mortems_reports (38 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at STRING
id STRING
incident__description STRING
incident__active BOOL
incident__created_at STRING
incident__created_by__email STRING
incident__created_by__id STRING
incident__created_by__name STRING
incident__created_by__source STRING
incident__current_milestone STRING
incident__customer_impact_summary STRING
incident__customers_impacted FLOAT64
incident__id STRING
incident__incident_url STRING
incident__last_note__body STRING
incident__last_note__created_at STRING
incident__last_note__id STRING
incident__last_update STRING
incident__name STRING
incident__number FLOAT64
incident__organization__id STRING
incident__organization__name STRING
incident__organization_id STRING
incident__priority STRING
incident__private_id STRING
incident__private_status_page_url STRING
incident__report_id STRING
incident__restricted BOOL
incident__severity STRING
incident__severity_color STRING
incident__started_at STRING
incident__summary STRING
incident_id STRING
name STRING
summary STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • post_mortems_reports__calendar_events (4 columns)
  • post_mortems_reports__incident__conference_bridges (4 columns)
  • post_mortems_reports__incident__conversations (9 columns)
  • post_mortems_reports__incident__custom_fields (11 columns)
  • post_mortems_reports__incident__environments (5 columns)
  • post_mortems_reports__incident__field_requirements (4 columns)
  • post_mortems_reports__incident__functionalities (5 columns)
  • post_mortems_reports__incident__impacts (10 columns)
  • post_mortems_reports__incident__impacts__conversations (8 columns)
  • post_mortems_reports__incident__incident_channels (4 columns)
  • post_mortems_reports__incident__incident_tickets (4 columns)
  • post_mortems_reports__incident__last_note__conversations (8 columns)
  • post_mortems_reports__incident__last_note__status_pages (4 columns)
  • post_mortems_reports__incident__lifecycle_measurements (11 columns)
  • post_mortems_reports__incident__lifecycle_phases (8 columns)
  • post_mortems_reports__incident__lifecycle_phases__milestones (15 columns)
  • post_mortems_reports__incident__milestones (9 columns)
  • post_mortems_reports__incident__retro_exports (4 columns)
  • post_mortems_reports__incident__role_assignments (19 columns)
  • post_mortems_reports__incident__role_assignments__user__signals_enabled_notification_types (4 columns)
  • post_mortems_reports__incident__services (5 columns)
  • post_mortems_reports__incident__status_pages (4 columns)
  • post_mortems_reports__incident__tag_list (4 columns)
  • post_mortems_reports__incident__team_assignments (4 columns)
  • post_mortems_reports__questions (9 columns)
  • post_mortems_reports__questions__conversations (8 columns)
  • post_mortems_reports__tag_list (4 columns)
priorities (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
created_at STRING
default BOOL
position FLOAT64
slug STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
reports (3 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
bucket STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • reports__points (5 columns)
runbook_actions (27 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
automatable BOOL
category STRING
config__documentation_url STRING
created_at STRING
default_rule_data___1__type STRING
default_rule_data___1__label STRING
default_rule_data___1__value STRING
id STRING
integration__description STRING
integration__created_at STRING
integration__deprecated BOOL
integration__enabled BOOL
integration__id STRING
integration__installed BOOL
integration__logo__logo_url STRING
integration__name STRING
integration__nat_ip STRING
integration__setup_url STRING
integration__slug STRING
name STRING
repeatable BOOL
rerunnable BOOL
slug STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • runbook_actions__config__elements (20 columns)
  • runbook_actions__config__elements__dynamic_select__options (5 columns)
  • runbook_actions__default_logic__eq (4 columns)
  • runbook_actions__default_logic__exists (4 columns)
  • runbook_actions__integration__connections (16 columns)
  • runbook_actions__prerequisites (6 columns)
  • runbook_actions__supported_runbook_types (4 columns)
runbook_audits (49 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
version FLOAT64
account_id FLOAT64
action STRING
auditable_id STRING
auditable_type STRING
audited_changes__account_id FLOAT64
audited_changes__action_id STRING
audited_changes__automatic BOOL
audited_changes__config__agenda STRING
audited_changes__config__body STRING
audited_changes__config__channel_name_format STRING
audited_changes__config__channel_visibility__label STRING
audited_changes__config__channel_visibility__value STRING
audited_changes__config__channels STRING
audited_changes__config__communications_channel_enabled__label STRING
audited_changes__config__communications_channel_enabled__value STRING
audited_changes__config__email_address STRING
audited_changes__config__message STRING
audited_changes__config__record_meeting__label STRING
audited_changes__config__record_meeting__value STRING
audited_changes__config__role__label STRING
audited_changes__config__role__value STRING
audited_changes__config__role_for_assignment__label STRING
audited_changes__config__role_for_assignment__value STRING
audited_changes__config__runbook__label STRING
audited_changes__config__runbook__value STRING
audited_changes__config__subject STRING
audited_changes__config__summary STRING
audited_changes__config__task_list__label STRING
audited_changes__config__task_list__value STRING
audited_changes__config__ticket_description STRING
audited_changes__config__ticket_summary STRING
audited_changes__config__topic STRING
audited_changes__config__user__label STRING
audited_changes__config__user__value STRING
audited_changes__delay_duration STRING
audited_changes__name STRING
audited_changes__organization_id STRING
audited_changes__position FLOAT64
audited_changes__repeats BOOL
audited_changes__repeats_duration STRING
audited_changes__reruns BOOL
audited_changes__runbook_id STRING
created_at STRING
id FLOAT64
user_id STRING
user_type STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
runbook_executions (20 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at STRING
created_by STRING
executed_for__type STRING
executed_for__id STRING
executed_for__name STRING
has_been_rerun BOOL
id STRING
runbook__type STRING
runbook__description STRING
runbook__created_at STRING
runbook__id STRING
runbook__name STRING
runbook__summary STRING
runbook__updated_at STRING
status STRING
status_reason STRING
status_reason_message STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • runbook_executions__runbook__categories (4 columns)
  • runbook_executions__steps (29 columns)
  • runbook_executions__steps__step_elements (7 columns)
runbooks (20 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
description STRING
created_at STRING
id STRING
name STRING
owner__description STRING
owner__created_at STRING
owner__created_by__email STRING
owner__created_by__id STRING
owner__created_by__name STRING
owner__created_by__source STRING
owner__id STRING
owner__name STRING
owner__signals_ical_url STRING
owner__slug STRING
owner__updated_at STRING
summary STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • runbooks__attachment_rule__logic__manually (4 columns)
  • runbooks__categories (4 columns)
scheduled_maintenances (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
created_at STRING
ends_at STRING
id STRING
name STRING
starts_at STRING
summary STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • scheduled_maintenances__impacts (4 columns)
  • scheduled_maintenances__status_pages (4 columns)
services (28 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
alert_on_add BOOL
auto_add_responding_team BOOL
completed_checks FLOAT64
created_at STRING
id STRING
labels__j STRING
name STRING
owner__description STRING
owner__created_at STRING
owner__created_by__email STRING
owner__created_by__id STRING
owner__created_by__name STRING
owner__created_by__source STRING
owner__id STRING
owner__name STRING
owner__signals_ical_url STRING
owner__slug STRING
owner__updated_at STRING
service_tier FLOAT64
slug STRING
updated_at STRING
updated_by__email STRING
updated_by__id STRING
updated_by__name STRING
updated_by__source STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • services__active_incidents (4 columns)
  • services__checklists (8 columns)
  • services__checklists__checks (6 columns)
  • services__external_resources (4 columns)
  • services__functionalities (4 columns)
  • services__links (4 columns)
  • services__teams (14 columns)
severities (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
description STRING
color STRING
created_at STRING
position FLOAT64
slug STRING
system_record BOOL
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
severity_matrix_conditions (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING
name STRING
position FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
severity_matrix_impacts (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
affects_id STRING
id STRING
name STRING
position FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
signals_on_call (36 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
created_at STRING
created_by__email STRING
created_by__id STRING
created_by__name STRING
created_by__source STRING
current_shift__color STRING
current_shift__end_time STRING
current_shift__id STRING
current_shift__on_call_schedule__id STRING
current_shift__on_call_schedule__name STRING
current_shift__start_time STRING
current_shift__team__id STRING
current_shift__team__name STRING
current_shift__time_zone STRING
current_shift__user__id STRING
current_shift__user__name STRING
id STRING
name STRING
next_shift__color STRING
next_shift__end_time STRING
next_shift__id STRING
next_shift__on_call_schedule__id STRING
next_shift__on_call_schedule__name STRING
next_shift__start_time STRING
next_shift__team__id STRING
next_shift__team__name STRING
next_shift__time_zone STRING
next_shift__user__id STRING
next_shift__user__name STRING
team__id STRING
team__name STRING
time_zone STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
task_lists (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
created_at STRING
created_by__email STRING
created_by__id STRING
created_by__name STRING
created_by__source STRING
id STRING
name STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
teams (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
created_at STRING
created_by__email STRING
created_by__id STRING
created_by__name STRING
created_by__source STRING
id STRING
name STRING
signals_ical_url STRING
slug STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • teams__functionalities (4 columns)
  • teams__memberships (15 columns)
  • teams__memberships__user__signals_enabled_notification_types (4 columns)
  • teams__owned_checklist_templates (8 columns)
  • teams__owned_checklist_templates__checks (6 columns)
  • teams__owned_functionalities (4 columns)
  • teams__owned_runbooks (21 columns)
  • teams__owned_runbooks__categories (4 columns)
  • teams__owned_services (13 columns)
  • teams__responding_services (4 columns)
  • teams__services (13 columns)
ticket_tags (3 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
ticketing_priorities (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at STRING
id STRING
name STRING
position FLOAT64
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
ticketing_projects (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING
name STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
tickets (19 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
description STRING
created_at STRING
created_by__email STRING
created_by__id STRING
created_by__name STRING
created_by__source STRING
id STRING
incident_id STRING
priority__created_at STRING
priority__id STRING
priority__name STRING
priority__position FLOAT64
priority__updated_at STRING
state STRING
summary STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • tickets__assignees (7 columns)
  • tickets__attachments (4 columns)
  • tickets__tag_list (4 columns)
users (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at STRING
email STRING
id STRING
name STRING
slack_linkedx BOOL
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • users__signals_enabled_notification_types (4 columns)
webhooks (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at STRING
created_by__email STRING
created_by__id STRING
created_by__name STRING
created_by__source STRING
id STRING
state STRING
updated_at STRING
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • webhooks__subscriptions (4 columns)

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where FireHydrant 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 FireHydrant?

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

It depends on how much history is in your FireHydrant 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 FireHydrant’s schema changes?

Section titled “What happens when FireHydrant’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 FireHydrant, 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 FireHydrant 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 FireHydrant connector in Kaivo and all of its synced data is deleted with it.

Use incidents and changes_events to track frequency, severity, and resolution over time.

Join services with incidents to find the systems that cause the most disruption.

Use incident_roles and signals_on_call to see how incident response load is shared.

Use FireHydrant data in your AI and BI tools

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

Once FireHydrant 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 FireHydrant 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 FireHydrant 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.