Skip to content
Book a demoStart free
Connectors

Zendesk Chat connector

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

Zendesk Chat connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Zendesk Chat 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 Zendesk Chat conversations and agents into BigQuery with Kaivo to analyse chat support alongside the rest of your data.

CategoryCustomer Service
AuthenticationAPI key
SetupSelf-service

Getting started with the Zendesk Chat connector

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

Field Description
Access Token
The Access Token to make authenticated requests.

|

When you set up the connector, you provide:

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

| | Subdomain |

The unique subdomain of your Zendesk account (without https://). See the Zendesk docs to find your subdomain.

|

Tables and columns synced from Zendesk Chat

Section titled “Tables and columns synced from Zendesk Chat”

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

accounts (46 columns), Accounts Stream: https://developer.zendesk.com/rest_api/docs/chat/accounts#show-account
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
account_key STRING
billing__additional_info STRING
billing__address1 STRING
billing__address2 STRING
billing__city STRING
billing__company STRING
billing__country_code STRING
billing__cycle INT64
billing__email STRING
billing__first_name STRING
billing__last_name STRING
billing__phone STRING
billing__postal_code STRING
billing__state STRING
create_date TIMESTAMP
plan__agent_leaderboard BOOL
plan__agent_reports BOOL
plan__analytics BOOL
plan__chat_reports BOOL
plan__daily_reports BOOL
plan__email_reports BOOL
plan__file_upload BOOL
plan__goals INT64
plan__high_load BOOL
plan__integrations BOOL
plan__ip_restriction BOOL
plan__long_desc STRING
plan__max_advanced_triggers STRING
plan__max_agents INT64
plan__max_basic_triggers STRING
plan__max_concurrent_chats STRING
plan__max_departments STRING
plan__max_history_search_days STRING
plan__monitoring BOOL
plan__name STRING
plan__operating_hours BOOL
plan__price FLOAT64
plan__rest_api BOOL
plan__short_desc STRING
plan__sla BOOL
plan__support BOOL
plan__unbranding BOOL
plan__widget_customization STRING
status STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
agent_timeline (8 columns), Agent Timelines Stream: https://developer.zendesk.com/rest_api/docs/chat/incremental_export#incremental-agent-timeline-export
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
agent_id INT64
duration FLOAT64
engagement_count INT64
id STRING
start_time TIMESTAMP
status STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
agents (15 columns), Agents Stream: https://developer.zendesk.com/rest_api/docs/chat/agents#list-agents
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
create_date TIMESTAMP
display_name STRING
email STRING
enabled BOOL
first_name STRING
id INT64
last_login TIMESTAMP
last_name STRING
login_count INT64
role_id INT64
roles__administrator BOOL
roles__owner BOOL
scope 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 INT64
_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.
value INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
bans (9 columns), Bans Stream: https://developer.zendesk.com/rest_api/docs/chat/bans#list-bans
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
create_date TIMESTAMP
id INT64
ip_address STRING
reason STRING
visitor_id STRING
visitor_name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
chats (31 columns), Chats Stream: https://developer.zendesk.com/api-reference/live-chat/chat-api/incremental_export/#incremental-chat-export
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
comment STRING
count__agent INT64
count__total INT64
count__visitor INT64
deleted BOOL
department_id INT64
department_name STRING
duration INT64
id STRING
message STRING
missed BOOL
rating STRING
response_time__avg FLOAT64
response_time__first INT64
response_time__max INT64
session JSON
started_by STRING
timestamp TIMESTAMP
triggered BOOL
triggered_response BOOL
unread BOOL
update_timestamp TIMESTAMP
visitor__email STRING
visitor__id STRING
visitor__name STRING
visitor__notes STRING
visitor__phone STRING
zendesk_ticket_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
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.
attribution__agent_id INT64
attribution__agent_name STRING
attribution__chat_timestamp TIMESTAMP
attribution__department_id INT64
attribution__department_name STRING
goal_id INT64
goal_name STRING
id STRING
timestamp TIMESTAMP
_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.
accepted BOOL
agent_full_name STRING
agent_id STRING
agent_name STRING
assigned BOOL
comment STRING
count__agent INT64
count__total INT64
count__visitor INT64
department_id INT64
duration FLOAT64
id STRING
rating STRING
response_time__avg FLOAT64
response_time__first INT64
response_time__max INT64
skills_fulfilled BOOL
started_by STRING
timestamp TIMESTAMP
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: chats__engagements__skills_requested

Section titled “Subtable: chats__engagements__skills_requested”
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.
type STRING
channel STRING
conversion__attribution__agent_id INT64
conversion__attribution__agent_name STRING
conversion__attribution__chat_timestamp TIMESTAMP
conversion__attribution__department_id INT64
conversion__attribution__department_name STRING
conversion__goal_id INT64
conversion__goal_name STRING
conversion__id STRING
conversion__timestamp TIMESTAMP
department_id STRING
department_name STRING
msg STRING
msg_id STRING
name STRING
new_rating STRING
nick STRING
options STRING
prev_department_id STRING
rating STRING
timestamp TIMESTAMP
_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.
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.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
from STRING
timestamp TIMESTAMP
title STRING
to STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
departments (6 columns), Departments Stream: https://developer.zendesk.com/rest_api/docs/chat/departments#list-departments
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
enabled BOOL
id INT64
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.
value INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
goals (8 columns), Goals Stream: https://developer.zendesk.com/rest_api/docs/chat/goals#list-goals
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
attribution_model STRING
attribution_period INT64
enabled BOOL
id INT64
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.
type STRING
operator STRING
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
roles (19 columns), Roles Stream: https://developer.zendesk.com/rest_api/docs/chat/roles#list-roles
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
enabled BOOL
id INT64
members_count INT64
name STRING
permissions__access_analytics STRING
permissions__edit_chat_tags BOOL
permissions__edit_department_agents STRING
permissions__edit_visitor_information BOOL
permissions__edit_visitor_notes BOOL
permissions__manage_bans STRING
permissions__manage_shortcuts STRING
permissions__proactive_chatting STRING
permissions__set_agent_chat_limit STRING
permissions__view_monitor STRING
permissions__view_past_chats STRING
permissions__visitors_seen STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
routing_settings (14 columns), Routing Settings Stream: https://developer.zendesk.com/rest_api/docs/chat/routing_settings#show-account-routing-settings
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
auto_idle__enabled BOOL
auto_idle__new_status STRING
auto_idle__reassignments_before_idle INT64
chat_limit__allow_agent_override BOOL
chat_limit__enabled BOOL
chat_limit__limit INT64
chat_limit__limit_type STRING
reassignment__enabled BOOL
reassignment__timeout INT64
routing_mode STRING
skill_routing__enabled BOOL
skill_routing__max_wait_time INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
shortcuts (7 columns), Shortcuts Stream: https://developer.zendesk.com/rest_api/docs/chat/shortcuts#list-shortcuts
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING
message STRING
name STRING
options STRING
scope 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 INT64
_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.
skills (6 columns), Skills Stream: https://developer.zendesk.com/rest_api/docs/chat/skills#list-skills
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
enabled BOOL
id INT64
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.
value INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
triggers (7 columns), Triggers Stream: https://developer.zendesk.com/rest_api/docs/chat/triggers#list-triggers
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
definition__version INT64
enabled BOOL
id INT64
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.
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.
value JSON
_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 Zendesk Chat 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 Zendesk Chat?

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

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

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

Use chats to track conversation volume by department and over time.

Analyse agents and agent_timeline to monitor workload and availability.

Measure response and resolution times to find where chat support slows down.

Join Zendesk Chat with your other support data in BigQuery for a full view.

Use Zendesk Chat data in your AI and BI tools

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

Once Zendesk Chat 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 Zendesk Chat 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 Zendesk Chat 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.