Skip to content
Book a demoStart free
Connectors

Front connector

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

Front connector pricing, tier and credits on kaivo.io

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

Sync your Front conversation data into BigQuery with Kaivo to measure response times, volume, and team performance across your shared inboxes.

CategoryCustomer Service
AuthenticationAPI key
SetupSelf-service
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Front 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
Front API token. In Front, go to Settings → Developers → API tokens and create one (requires admin access). See Front’s guide for steps.

|

When you set up the connector, you provide:

Field Description
Start Date
Any data before this date will not be fetched.

|

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

accounts (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
_links__related__contacts STRING
_links__self STRING
created_at FLOAT64
id STRING
name STRING
updated_at FLOAT64
_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.
accounts_contacts (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
_links__related__conversations STRING
_links__related__notes STRING
_links__self STRING
account__description STRING
account___links__related__contacts STRING
account___links__self STRING
account__created_at FLOAT64
account__id STRING
account__name STRING
account__updated_at FLOAT64
id STRING
is_private BOOL
name STRING
updated_at FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: accounts_contacts__account__domains

Section titled “Subtable: accounts_contacts__account__domains”
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.
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.
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.
handle STRING
source 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.
channels (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
_links__related__inbox STRING
_links__related__owner STRING
_links__self STRING
address STRING
id STRING
is_private BOOL
is_valid BOOL
name STRING
send_as STRING
settings__all_teammates_can_reply BOOL
settings__undo_send_time FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
company_tags (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
_links__related__conversations STRING
_links__self STRING
created_at FLOAT64
highlight STRING
id STRING
is_private BOOL
is_visible_in_conversation_lists BOOL
name STRING
updated_at FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
contact_groups (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_links__related__contacts STRING
_links__self STRING
id STRING
is_private BOOL
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
contacts (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
_links__related__conversations STRING
_links__related__notes STRING
_links__self STRING
avatar_url STRING
id STRING
is_private BOOL
name STRING
updated_at FLOAT64
_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.
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.
handle STRING
source 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.
contacts_notes (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_links__related__author STRING
author___links__related__conversations STRING
author___links__related__inboxes STRING
author___links__self STRING
author__email STRING
author__first_name STRING
author__id STRING
author__is_admin BOOL
author__is_available BOOL
author__is_blocked BOOL
author__last_name STRING
author__username STRING
body STRING
created_at FLOAT64
is_private BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
conversations (30 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_links__related__comments STRING
_links__related__events STRING
_links__related__followers STRING
_links__related__inboxes STRING
_links__related__last_message STRING
_links__related__messages STRING
_links__self STRING
assignee___links__related__conversations STRING
assignee___links__related__inboxes STRING
assignee___links__self STRING
assignee__email STRING
assignee__first_name STRING
assignee__id STRING
assignee__is_admin BOOL
assignee__is_available BOOL
assignee__is_blocked BOOL
assignee__last_name STRING
assignee__username STRING
created_at FLOAT64
id STRING
is_private BOOL
recipient___links__related__contact STRING
recipient__handle STRING
recipient__name STRING
recipient__role STRING
status STRING
subject STRING
waiting_since FLOAT64
_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.

Subtable: conversations__scheduled_reminders

Section titled “Subtable: conversations__scheduled_reminders”
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.
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.
description STRING
_links__related__conversations STRING
_links__related__owner STRING
_links__self STRING
created_at FLOAT64
highlight STRING
id STRING
is_private BOOL
is_visible_in_conversation_lists BOOL
name STRING
updated_at FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
conversations_drafts (28 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
version STRING
type STRING
_links__related__conversation STRING
_links__related__message_replied_to STRING
_links__related__message_seen STRING
_links__self STRING
author___links__related__conversations STRING
author___links__related__inboxes STRING
author___links__self STRING
author__email STRING
author__first_name STRING
author__id STRING
author__is_admin BOOL
author__is_available BOOL
author__is_blocked BOOL
author__last_name STRING
author__username STRING
blurb STRING
body STRING
created_at FLOAT64
draft_mode STRING
id STRING
is_draft BOOL
is_inbound BOOL
subject STRING
text STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: conversations_drafts__attachments

Section titled “Subtable: conversations_drafts__attachments”
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: conversations_drafts__recipients

Section titled “Subtable: conversations_drafts__recipients”
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.
handle STRING
name STRING
role STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
conversations_events (78 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
_links__self STRING
conversation___links__related__comments STRING
conversation___links__related__events STRING
conversation___links__related__followers STRING
conversation___links__related__inboxes STRING
conversation___links__related__last_message STRING
conversation___links__related__messages STRING
conversation___links__self STRING
conversation__assignee___links__related__conversations STRING
conversation__assignee___links__related__inboxes STRING
conversation__assignee___links__self STRING
conversation__assignee__email STRING
conversation__assignee__first_name STRING
conversation__assignee__id STRING
conversation__assignee__is_admin BOOL
conversation__assignee__is_available BOOL
conversation__assignee__is_blocked BOOL
conversation__assignee__last_name STRING
conversation__assignee__username STRING
conversation__created_at FLOAT64
conversation__id STRING
conversation__is_private BOOL
conversation__recipient___links__related__contact STRING
conversation__recipient__handle STRING
conversation__recipient__name STRING
conversation__recipient__role STRING
conversation__status STRING
conversation__subject STRING
conversation__waiting_since FLOAT64
emitted_at FLOAT64
id STRING
source___meta__type STRING
source__data JSON
target___meta__type STRING
target__data__type STRING
target__data___links__related__conversation STRING
target__data___links__related__conversations STRING
target__data___links__related__inboxes STRING
target__data___links__related__mentions STRING
target__data___links__related__message_seen STRING
target__data___links__related__owner STRING
target__data___links__self STRING
target__data__author___links__related__conversations STRING
target__data__author___links__related__inboxes STRING
target__data__author___links__self STRING
target__data__author__email STRING
target__data__author__first_name STRING
target__data__author__id STRING
target__data__author__is_admin BOOL
target__data__author__is_available BOOL
target__data__author__is_blocked BOOL
target__data__author__last_name STRING
target__data__author__username STRING
target__data__blurb STRING
target__data__body STRING
target__data__created_at FLOAT64
target__data__email STRING
target__data__first_name STRING
target__data__highlight STRING
target__data__id STRING
target__data__is_admin BOOL
target__data__is_available BOOL
target__data__is_blocked BOOL
target__data__is_draft BOOL
target__data__is_inbound BOOL
target__data__is_pinned BOOL
target__data__is_private BOOL
target__data__is_visible_in_conversation_lists BOOL
target__data__last_name STRING
target__data__name STRING
target__data__posted_at FLOAT64
target__data__subject STRING
target__data__text STRING
target__data__updated_at FLOAT64
target__data__username STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Section titled “Subtable: conversations_events__conversation__links”
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: conversations_events__conversation__scheduled_reminders

Section titled “Subtable: conversations_events__conversation__scheduled_reminders”
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: conversations_events__conversation__tags

Section titled “Subtable: conversations_events__conversation__tags”
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.
description STRING
_links__related__conversations STRING
_links__related__owner STRING
_links__self STRING
created_at FLOAT64
highlight STRING
id STRING
is_private BOOL
is_visible_in_conversation_lists BOOL
name STRING
updated_at FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: conversations_events__target__data__attachments

Section titled “Subtable: conversations_events__target__data__attachments”
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: conversations_events__target__data__recipients

Section titled “Subtable: conversations_events__target__data__recipients”
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.
_links__related__contact STRING
handle STRING
name STRING
role STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
conversations_followers (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_links__related__conversations STRING
_links__related__inboxes STRING
_links__self STRING
email STRING
first_name STRING
id STRING
is_admin BOOL
is_available BOOL
is_blocked BOOL
last_name STRING
username STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
conversations_inboxes (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
_links__related__channels STRING
_links__related__conversations STRING
_links__related__owner STRING
_links__related__teammates STRING
_links__self STRING
address STRING
id STRING
is_private BOOL
is_public BOOL
name STRING
send_as STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
conversations_messages (25 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
_links__related__conversation STRING
_links__related__message_seen STRING
_links__self STRING
author___links__related__conversations STRING
author___links__related__inboxes STRING
author___links__self STRING
author__email STRING
author__first_name STRING
author__id STRING
author__is_admin BOOL
author__is_available BOOL
author__is_blocked BOOL
author__last_name STRING
author__username STRING
blurb STRING
body STRING
created_at FLOAT64
id STRING
is_draft BOOL
is_inbound BOOL
subject STRING
text STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: conversations_messages__attachments

Section titled “Subtable: conversations_messages__attachments”
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: conversations_messages__recipients

Section titled “Subtable: conversations_messages__recipients”
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.
_links__related__contact STRING
handle STRING
name STRING
role STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
events (78 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
_links__self STRING
conversation___links__related__comments STRING
conversation___links__related__events STRING
conversation___links__related__followers STRING
conversation___links__related__inboxes STRING
conversation___links__related__last_message STRING
conversation___links__related__messages STRING
conversation___links__self STRING
conversation__assignee___links__related__conversations STRING
conversation__assignee___links__related__inboxes STRING
conversation__assignee___links__self STRING
conversation__assignee__email STRING
conversation__assignee__first_name STRING
conversation__assignee__id STRING
conversation__assignee__is_admin BOOL
conversation__assignee__is_available BOOL
conversation__assignee__is_blocked BOOL
conversation__assignee__last_name STRING
conversation__assignee__username STRING
conversation__created_at FLOAT64
conversation__id STRING
conversation__is_private BOOL
conversation__recipient___links__related__contact STRING
conversation__recipient__handle STRING
conversation__recipient__name STRING
conversation__recipient__role STRING
conversation__status STRING
conversation__subject STRING
conversation__waiting_since FLOAT64
emitted_at FLOAT64
id STRING
source___meta__type STRING
source__data JSON
target___meta__type STRING
target__data__type STRING
target__data___links__related__conversation STRING
target__data___links__related__conversations STRING
target__data___links__related__inboxes STRING
target__data___links__related__mentions STRING
target__data___links__related__message_seen STRING
target__data___links__related__owner STRING
target__data___links__self STRING
target__data__author___links__related__conversations STRING
target__data__author___links__related__inboxes STRING
target__data__author___links__self STRING
target__data__author__email STRING
target__data__author__first_name STRING
target__data__author__id STRING
target__data__author__is_admin BOOL
target__data__author__is_available BOOL
target__data__author__is_blocked BOOL
target__data__author__last_name STRING
target__data__author__username STRING
target__data__blurb STRING
target__data__body STRING
target__data__created_at FLOAT64
target__data__email STRING
target__data__first_name STRING
target__data__highlight STRING
target__data__id STRING
target__data__is_admin BOOL
target__data__is_available BOOL
target__data__is_blocked BOOL
target__data__is_draft BOOL
target__data__is_inbound BOOL
target__data__is_pinned BOOL
target__data__is_private BOOL
target__data__is_visible_in_conversation_lists BOOL
target__data__last_name STRING
target__data__name STRING
target__data__posted_at FLOAT64
target__data__subject STRING
target__data__text STRING
target__data__updated_at FLOAT64
target__data__username 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.

Subtable: events__conversation__scheduled_reminders

Section titled “Subtable: events__conversation__scheduled_reminders”
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.
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.
description STRING
_links__related__conversations STRING
_links__related__owner STRING
_links__self STRING
created_at FLOAT64
highlight STRING
id STRING
is_private BOOL
is_visible_in_conversation_lists BOOL
name STRING
updated_at FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: events__target__data__attachments

Section titled “Subtable: events__target__data__attachments”
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: events__target__data__recipients

Section titled “Subtable: events__target__data__recipients”
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.
_links__related__contact STRING
handle STRING
name STRING
role STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
inboxes (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
_links__related__channels STRING
_links__related__conversations STRING
_links__related__owner STRING
_links__related__teammates STRING
_links__self STRING
address STRING
id STRING
is_private BOOL
is_public BOOL
name STRING
send_as STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
inboxes_channels (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
_links__related__inbox STRING
_links__related__owner STRING
_links__self STRING
address STRING
id STRING
is_private BOOL
is_valid BOOL
name STRING
send_as STRING
settings__all_teammates_can_reply BOOL
settings__undo_send_time FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
inboxes_conversations (29 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_links__related__comments STRING
_links__related__events STRING
_links__related__followers STRING
_links__related__inboxes STRING
_links__related__last_message STRING
_links__related__messages STRING
_links__self STRING
assignee___links__related__conversations STRING
assignee___links__related__inboxes STRING
assignee___links__self STRING
assignee__email STRING
assignee__first_name STRING
assignee__id STRING
assignee__is_admin BOOL
assignee__is_available BOOL
assignee__is_blocked BOOL
assignee__last_name STRING
assignee__username STRING
created_at FLOAT64
id STRING
is_private BOOL
recipient__handle STRING
recipient__name STRING
recipient__role STRING
status STRING
subject STRING
waiting_since FLOAT64
_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.

Subtable: inboxes_conversations__scheduled_reminders

Section titled “Subtable: inboxes_conversations__scheduled_reminders”
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.
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.
description STRING
_links__related__conversations STRING
_links__related__owner STRING
_links__self STRING
created_at FLOAT64
highlight STRING
id STRING
is_private BOOL
is_visible_in_conversation_lists BOOL
name STRING
updated_at FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
inboxes_teammates (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_links__related__conversations STRING
_links__related__inboxes STRING
_links__self STRING
email STRING
first_name STRING
id STRING
is_admin BOOL
is_available BOOL
is_blocked BOOL
last_name STRING
username STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
knowledge_bases (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
_links__related__articles STRING
_links__related__categories STRING
_links__related__content STRING
_links__self STRING
created_at FLOAT64
id STRING
updated_at FLOAT64
_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.
knowledge_bases_articles (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_links__related__content STRING
_links__related__knowledge_base STRING
_links__self STRING
created_at FLOAT64
id STRING
updated_at FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: knowledge_bases_articles__locales

Section titled “Subtable: knowledge_bases_articles__locales”
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.
knowledge_bases_categories (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_links__related__articles STRING
_links__related__content STRING
_links__related__knowledge_base STRING
_links__self STRING
created_at FLOAT64
id STRING
is_hidden BOOL
updated_at FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: knowledge_bases_categories__locales

Section titled “Subtable: knowledge_bases_categories__locales”
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.
links (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
_links__self STRING
external_url STRING
id STRING
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
message_template_folders (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_links__related__child_folders STRING
_links__related__owner STRING
_links__related__parent_folder STRING
_links__self STRING
created_at FLOAT64
id STRING
name STRING
updated_at FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
message_templates (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_links__related__owner STRING
_links__related__parent_folder STRING
_links__self STRING
body STRING
created_at FLOAT64
id STRING
is_available_for_all_inboxes BOOL
name STRING
subject STRING
updated_at FLOAT64
_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.
tags (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
_links__related__children STRING
_links__related__conversations STRING
_links__related__owner STRING
_links__related__parent_tag STRING
_links__self STRING
created_at FLOAT64
highlight STRING
id STRING
is_private BOOL
is_visible_in_conversation_lists BOOL
name STRING
updated_at FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
tags_children (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
_links__related__conversations STRING
_links__related__parent_tag STRING
_links__self STRING
created_at FLOAT64
highlight STRING
id STRING
is_private BOOL
is_visible_in_conversation_lists BOOL
name STRING
updated_at FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
teammates (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_links__related__conversations STRING
_links__related__inboxes STRING
_links__self STRING
email STRING
first_name STRING
id STRING
is_admin BOOL
is_available BOOL
is_blocked BOOL
last_name STRING
username STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
teammates_contact_groups (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_links__related__contacts STRING
_links__related__owner STRING
_links__self STRING
id STRING
is_private BOOL
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
teammates_message_templates (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_links__related__owner STRING
_links__self STRING
body STRING
created_at FLOAT64
id STRING
is_available_for_all_inboxes BOOL
name STRING
subject STRING
updated_at FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: teammates_message_templates__attachments

Section titled “Subtable: teammates_message_templates__attachments”
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.
teammates_tags (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
_links__related__conversations STRING
_links__related__owner STRING
_links__self STRING
created_at FLOAT64
highlight STRING
id STRING
is_private BOOL
is_visible_in_conversation_lists BOOL
name STRING
updated_at FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
teams (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_links__self STRING
id STRING
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
teams_contact_groups (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_links__related__contacts STRING
_links__self STRING
id STRING
is_private BOOL
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
teams_message_templates (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_links__related__owner STRING
_links__related__parent_folder STRING
_links__self STRING
body STRING
created_at FLOAT64
id STRING
is_available_for_all_inboxes BOOL
name STRING
subject STRING
updated_at FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: teams_message_templates__attachments

Section titled “Subtable: teams_message_templates__attachments”
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.
teams_signatures (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_links__related__owner STRING
_links__self STRING
body STRING
id STRING
is_default BOOL
is_private BOOL
is_visible_for_all_teammate_channels BOOL
name STRING
sender_info STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
teams_tags (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
_links__related__conversations STRING
_links__related__owner STRING
_links__self STRING
created_at FLOAT64
highlight STRING
id STRING
is_private BOOL
is_visible_in_conversation_lists BOOL
name STRING
updated_at FLOAT64
_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 Front 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 Front?

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

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

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

Use conversations and conversations_events to measure first response and resolution times.

Group conversations by inbox to see where support load is concentrated.

Join conversations with teammates to compare workload and handling across the team.

Use tags to understand what customers contact you about most.

Once Front 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 Front 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 Front connector pricing and plan details.

  • HubSpot: Sync HubSpot to BigQuery.
  • Dixa: Sync Dixa to BigQuery.
  • Freshservice: Sync Freshservice to BigQuery.
  • Genesys: Sync Genesys to BigQuery.
  • Gorgias: Sync Gorgias to BigQuery.
  • giosg: Sync giosg to BigQuery.