Skip to content
Book a demoStart free
Connectors

Instatus connector

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

Instatus connector pricing, tier and credits on kaivo.io

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

Sync your Instatus status page data into BigQuery with Kaivo to analyse incidents, uptime, and subscribers over time.

CategoryTech
AuthenticationAPI key
SetupSelf-service

Getting started with the Instatus connector

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

|

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

incident_updates (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING
incident__id STRING
incident__name STRING
incident__started TIMESTAMP
incident__status STRING
message STRING
message_html STRING
notify BOOL
started TIMESTAMP
status STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: incident_updates__incident__components

Section titled “Subtable: incident_updates__incident__components”
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.
id STRING
name STRING
show_uptime BOOL
site__logo_url STRING
site__name STRING
site__subdomain STRING
status STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: incident_updates__incident__components__site__slack_integrations

Section titled “Subtable: incident_updates__incident__components__site__slack_integrations”
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 JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: incident_updates__incident__components__site__subscribers

Section titled “Subtable: incident_updates__incident__components__site__subscribers”
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.
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: incident_updates__incident__components__subscribers

Section titled “Subtable: incident_updates__incident__components__subscribers”
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.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
incidents (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING
name STRING
resolved TIMESTAMP
started TIMESTAMP
status 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.
id STRING
name STRING
show_uptime BOOL
site__color BOOL
site__id STRING
site__logo_url STRING
site__name STRING
site__public_email STRING
site__subdomain STRING
status 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.
created_at TIMESTAMP
duration INT64
ended TIMESTAMP
id STRING
message STRING
message_html STRING
notify BOOL
started TIMESTAMP
status 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 JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
maintenance_updates (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING
maintenance__id STRING
maintenance__name STRING
maintenance__start TIMESTAMP
maintenance__status STRING
message STRING
message_html STRING
notify BOOL
started TIMESTAMP
status STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: maintenance_updates__maintenance__components

Section titled “Subtable: maintenance_updates__maintenance__components”
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.
id STRING
name STRING
show_uptime BOOL
site__color STRING
site__id STRING
site__logo_url STRING
site__name STRING
site__public_email STRING
site__subdomain STRING
status STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
maintenances (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
auto_end BOOL
auto_start BOOL
duration INT64
id STRING
name STRING
notify_early BOOL
notify_end BOOL
notify_minutes INT64
notify_start BOOL
start TIMESTAMP
status 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.
id STRING
name STRING
show_uptime BOOL
site__color BOOL
site__id STRING
site__logo_url STRING
site__name STRING
site__public_email STRING
site__subdomain STRING
status 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.
created_at TIMESTAMP
duration INT64
ended TIMESTAMP
id STRING
message STRING
message_html STRING
notify BOOL
started TIMESTAMP
status STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
metrics (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
active BOOL
id STRING
name STRING
order INT64
suffix 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.
properties JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
page_components (31 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
group__description STRING
group__closed BOOL
group__created_at TIMESTAMP
group__description_html STRING
group__description_translation_id STRING
group__id STRING
group__imported_from_statuspage BOOL
group__name STRING
group__name_html STRING
group__name_html_translation_id STRING
group__order INT64
group__show_uptime BOOL
group__site_id STRING
group__titled BOOL
group__translations__description STRING
group__translations__name STRING
group__updated_at TIMESTAMP
id STRING
name STRING
order INT64
show_uptime BOOL
status STRING
unique_email STRING
updates__id STRING
updates__message STRING
updates__message_html STRING
updates__started TIMESTAMP
updates__status 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.
components JSON
id STRING
name STRING
started TIMESTAMP
status STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
public_data (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
page__name STRING
page__status STRING
page__url 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.
impact STRING
name STRING
started STRING
status STRING
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: public_data__active_maintenances

Section titled “Subtable: public_data__active_maintenances”
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.
duration STRING
name STRING
start STRING
status STRING
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
status_pages (35 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
brand_color STRING
created_at TIMESTAMP
css_global STRING
custom_domain STRING
degraded_color STRING
disrupted_color STRING
down_color STRING
favicon_url STRING
google_analytics STRING
html_above_footer STRING
html_above_header STRING
html_below_footer STRING
html_below_header STRING
html_below_summary STRING
html_in_meta STRING
id STRING
language STRING
launch_date TIMESTAMP
logo_url STRING
name STRING
notice_color STRING
ok_color STRING
onboarded BOOL
public_email STRING
sms_service STRING
status STRING
subdomain STRING
subscribe_by_sms BOOL
twitter STRING
unknown_color STRING
updated_at TIMESTAMP
use_large_header BOOL
website_url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
subscribers (33 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
all BOOL
approved BOOL
company STRING
confirmed BOOL
created_at TIMESTAMP
discord STRING
discord_team STRING
email STRING
failed_attempts INT64
google_chat_space STRING
google_chat_webhook STRING
hide_unsub_link BOOL
id STRING
imported_from_statuspage BOOL
language STRING
microsoft_teams_webhook STRING
name STRING
phone STRING
site_id STRING
slack STRING
slack_team STRING
unsubscribe_token STRING
updated_at TIMESTAMP
webhook STRING
webhook_component_body STRING
webhook_email STRING
webhook_headers STRING
webhook_http_method STRING
webhook_incident_body STRING
webhook_maintenance_body STRING
webhook_query_params 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.
color BOOL
id STRING
logo_url BOOL
name STRING
public_email BOOL
subdomain STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
team (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
avatar STRING
email STRING
id STRING
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
templates (18 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
created_at TIMESTAMP
deleted_at TIMESTAMP
id STRING
imported_from_statuspage BOOL
message STRING
message_html STRING
message_html_translation_id STRING
message_translation_id STRING
name STRING
name_translation_id STRING
notify BOOL
site_id STRING
status STRING
translations__message STRING
translations__name 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.
id STRING
name STRING
show_uptime BOOL
site__color STRING
site__id STRING
site__logo_url STRING
site__name STRING
site__public_email STRING
site__subdomain STRING
status STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
user (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
avatar STRING
email STRING
id STRING
name STRING
slug 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 Instatus 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 Instatus?

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

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

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

Use incidents and incident_updates to track frequency and duration over time.

Join page_components with incidents to find which systems cause the most disruption.

Use subscribers to see how your status audience grows.

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