Skip to content
Book a demoStart free
Connectors

Zendesk Support connector

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

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

Kaivo is a fully managed data platform that syncs your Zendesk Support 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 Support tickets and fields into BigQuery with Kaivo to analyse support performance alongside the rest of your data.

CategoryCustomer Service
AuthenticationAPI key
SetupSelf-service

Getting started with the Zendesk Support connector

Section titled “Getting started with the Zendesk Support connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Zendesk Support 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 Zendesk Support credentials. You provide:

Field Description
Email
The user email for your Zendesk account.

| | API Token |

The API token for your Zendesk account. See the Zendesk documentation for more information on generating this token.

|

When you set up the connector, you provide:

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

| | Subdomain |

Your unique Zendesk subdomain found in your account URL. For example, in https://MY_SUBDOMAIN.zendesk.com/, MY_SUBDOMAIN is your subdomain.

|

Tables and columns synced from Zendesk Support

Section titled “Tables and columns synced from Zendesk Support”

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

account_attributes (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING The unique identifier for the account attribute.
name STRING The name or label of the account attribute.
created_at TIMESTAMP The timestamp indicating when the account attribute was created.
updated_at TIMESTAMP The timestamp indicating when the account attribute was last updated.
url STRING The URL that can be used to access the account attribute.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
article_attachments (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 Assigned ID when the article attachment is created.
url STRING The URL of the article attachment.
article_id INT64 The associated article, if present.
display_file_name STRING The file name displayed.
file_name STRING The file name.
locale STRING TThe locale of translation that the attachment will be attached to and can only be set on inline attachments.
content_url STRING URL where the attachment file can be downloaded.
relative_path STRING Relative path of the file.
content_type STRING The file type. Example: image/png
size INT64 The attachment file size in bytes.
inline BOOL The attached file is shown in the admin interface for inline attachments.
created_at TIMESTAMP The time the article attachment was created.
updated_at TIMESTAMP The time the article attachment was last updated.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
article_comment_votes (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at TIMESTAMP Timestamp when the vote was created
id INT64 Unique identifier for the vote
item_id INT64 Identifier of the item that was voted on
item_type STRING Type of the item that was voted on (e.g., ticket, article)
updated_at TIMESTAMP Timestamp when the vote was last updated
url STRING URL of the resource related to the vote
user_id INT64 Unique identifier of the user who voted
value INT64 Value of the vote (e.g., upvote, downvote)
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
article_comments (16 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
author_id INT64 The unique identifier of the author of the comment.
body STRING The content or text of the comment.
created_at TIMESTAMP The timestamp when the comment was created.
html_url STRING The URL link to the HTML representation of the comment.
id INT64 The unique identifier of the comment.
locale STRING The locale or language of the comment.
non_author_editor_id INT64 The unique identifier of a non-author who edited the comment.
non_author_updated_at TIMESTAMP The timestamp when the non-author last updated the comment.
source_id INT64 The ID of the source associated with the comment.
source_type STRING The type of the source associated with the comment.
updated_at TIMESTAMP The timestamp when the comment was last updated.
url STRING The URL link to the comment resource.
vote_count INT64 The total count of votes received on the comment.
vote_sum INT64 The sum of votes received on the comment, considering upvotes and downvotes.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
article_votes (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at TIMESTAMP Timestamp when the vote was created
id INT64 Unique identifier for the vote
item_id INT64 Identifier of the item that was voted on
item_type STRING Type of the item that was voted on (e.g., ticket, article)
updated_at TIMESTAMP Timestamp when the vote was last updated
url STRING URL of the resource related to the vote
user_id INT64 Unique identifier of the user who voted
value INT64 Value of the vote (e.g., upvote, downvote)
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
articles (24 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
author_id INT64 The unique identifier of the author who created the article.
body STRING The main content or body of the article.
comments_disabled BOOL Indicates whether comments are disabled for the article.
created_at TIMESTAMP The date and time when the article was created.
draft BOOL Indicates whether the article is in draft mode.
edited_at TIMESTAMP The date and time when the article was last edited.
html_url STRING The URL of the article in HTML format.
id INT64 The unique identifier of the article.
locale STRING The language locale of the article.
name STRING The name of the article.
outdated BOOL Indicates whether the article is outdated.
permission_group_id INT64 The unique identifier of the permission group for the article.
position INT64 The position order of the article within its section.
promoted BOOL Indicates whether the article is promoted.
section_id INT64 The unique identifier of the section to which the article belongs.
source_locale STRING The original language locale of the article.
title STRING The title or heading of the article.
updated_at TIMESTAMP The date and time when the article was last updated.
url STRING The URL of the article.
user_segment_id INT64 The unique identifier of the user segment targeted by the article.
vote_count INT64 The total count of votes received for the article.
vote_sum INT64 The sum of votes received for the article (considering upvotes and downvotes).
_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.

  • articles__content_tag_ids (4 columns)
  • articles__label_names (4 columns)
  • articles__outdated_locales (4 columns)
attribute_definitions (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
title STRING Title of the attribute definition.
subject STRING Subject or topic of this attribute definition.
type STRING Data type of the attribute.
group STRING The group to which this attribute definition belongs.
nullable BOOL Indicates if this attribute definition can be null.
repeatable BOOL Specifies if this attribute definition can be repeated.
condition STRING The condition that needs to be met for this attribute definition.
confition STRING Missing field description, please add.
metadata__collection_key STRING Key for the collection associated with this metadata.
metadata__item_key STRING Key for the item associated with this metadata.
_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.

  • attribute_definitions__operators (6 columns)
  • attribute_definitions__values (6 columns)
audit_logs (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
action STRING The type of action performed in the audit log.
action_label STRING A human-readable label representing the action.
actor_id FLOAT64 The ID of the actor (user) who performed the action.
actor_name STRING The name of the actor (user) who performed the action.
change_description STRING Description of the change made.
created_at TIMESTAMP The date and time when the audit log entry was created.
id FLOAT64 Unique identifier for the audit log entry.
ip_address STRING The IP address from which the action was performed.
source_id FLOAT64 The ID of the source object related to the action.
source_label STRING A human-readable label representing the source object.
source_type STRING The type of the source object.
url STRING The URL associated with the action or source object.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
automations (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
active BOOL Whether the automation is active
created_at STRING The time the automation was created
default BOOL If true, the automation is a default automation
id INT64 Automatically assigned when created
position INT64 The position of the automation which specifies the order it will be executed
raw_title STRING The raw title of the automation
title STRING The title of the automation
updated_at STRING The time of the last update of the automation
_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.

  • automations__actions (5 columns)
  • automations__conditions__all (6 columns)
  • automations__conditions__any (6 columns)
brands (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 Unique identifier for the brand.
name STRING Name of the brand.
logo STRING URL of the brand’s logo.
brand_url STRING URL of the brand’s website.
host_mapping STRING Mapping for the brand’s host.
subdomain STRING Subdomain assigned to the brand.
url STRING URL of the brand’s API endpoint.
signature_template STRING Template for the brand’s signature.
has_help_center BOOL Indicates whether the brand has a help center.
help_center_state STRING State of the help center for the brand.
active BOOL Indicates whether the brand is currently active or not.
default BOOL Indicates if the brand is the default brand.
is_deleted BOOL Indicates if the brand has been deleted.
created_at TIMESTAMP Timestamp of when the brand was created.
updated_at TIMESTAMP Timestamp of when the brand was last updated.
_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.

  • brands__ticket_form_ids (4 columns)
categories (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 Unique identifier for the category.
name STRING Name of the category.
position INT64 The position of this category relative to other categories.
description STRING The description of the category.
locale STRING The locale where the category is displayed.
url STRING The API url of this category.
html_url STRING The url of this category in Help Center.
source_locale STRING The source (default) locale of the category.
outdated STRING Whether the category is out of date.
created_at TIMESTAMP Timestamp of when the category was created.
updated_at TIMESTAMP Timestamp of when the category was last updated.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
custom_roles (64 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 Unique identifier of the custom role
name STRING Name of the custom role
description STRING Brief description of the custom role
role_type INT64 Type of the custom role (e.g., admin, agent, etc)
team_member_count INT64 Number of team members with this custom role
configuration__assign_tickets_to_any_group BOOL Allows assigning tickets to any group within the organization
configuration__chat_access BOOL Grants access to chat functionality
configuration__manage_automations BOOL Permission to manage automations
configuration__manage_group_memberships BOOL Ability to manage group memberships
configuration__manage_groups BOOL Permission to manage groups
configuration__manage_macro_content_suggestions BOOL Ability to manage macro content suggestions
configuration__manage_organizations BOOL Ability to manage organizations
configuration__manage_skills BOOL Ability to manage skills
configuration__manage_suspended_tickets BOOL Ability to manage suspended tickets
configuration__manage_triggers BOOL Ability to manage triggers
configuration__manage_slas BOOL Permission to manage SLAs (Service Level Agreements)
configuration__read_macro_content_suggestions BOOL Access for reading macro content suggestions
configuration__ticket_redaction BOOL Ability to redact sensitive information from tickets
configuration__view_filter_tickets BOOL Ability to filter and search through tickets
configuration__view_reduced_count BOOL View reduced counts of specific data
configuration__manage_roles STRING Permissions related to managing roles
configuration__manage_deletion_schedules STRING Ability to manage deletion schedules
configuration__end_user_list_access STRING Enables access to the end user list
configuration__end_user_profile_access STRING Allows viewing and editing end user profiles
… and 39 more columns
deleted_tickets (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
actor__id INT64 The unique identifier of the user
actor__name STRING The name of the user
id INT64 The unique identifier of the deleted ticket
subject STRING The subject or title of the deleted ticket
description STRING Additional details or comments about the deleted ticket
deleted_at TIMESTAMP The timestamp when the ticket was deleted
previous_state STRING The state of the ticket before it was deleted
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
group_memberships (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
default BOOL Flag indicating if this group membership is the default one.
url STRING URL pointing to the group membership resource.
user_id INT64 The unique identifier of the user associated with this group membership.
updated_at TIMESTAMP Timestamp indicating when the group membership was last updated.
group_id INT64 The unique identifier of the group this membership belongs to.
created_at TIMESTAMP Timestamp indicating when the group membership was created.
id INT64 The unique identifier of the group membership.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
groups (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
name STRING The name of the group.
created_at TIMESTAMP The date and time when the group was created.
url STRING The URL of the group.
updated_at TIMESTAMP The date and time when the group was last updated.
default BOOL Indicates if the group is set as the default group.
deleted BOOL Indicates if the group has been deleted.
description STRING The description or details about the group.
id INT64 The unique identifier of the group.
is_public BOOL Indicates whether the group is public or private.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
macros (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 Unique identifier for the macro
position INT64 The position/order of the macro
restriction__id INT64 Unique identifier for the restriction
restriction__type STRING Type of restriction applied
title STRING The title of the macro
created_at TIMESTAMP The date and time when the macro was created
url STRING URL to access the macro details
description STRING Additional information or notes about the macro
default BOOL Indicates if the macro is set as the default
updated_at TIMESTAMP The date and time when the macro was last updated
active BOOL Indicates if the macro is currently active
raw_title STRING The title of the macro in its raw form
_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.

  • macros__restriction__ids (4 columns)
  • macros__actions (5 columns)
organization_fields (18 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
active BOOL Indicates whether the organization field is currently active or not
created_at TIMESTAMP The date and time when the organization field was created
description STRING The description of the organization field
id INT64 The unique identifier of the organization field
key STRING The key associated with the organization field
position INT64 The position of the organization field
raw_description STRING The raw description of the organization field
raw_title STRING The raw title of the organization field
regexp_for_validation STRING Regular expression for validation of the organization field data
relationship_target_type STRING The target type of the relationship for this organization field
system BOOL Indicates whether the organization field is a system field or not
tag STRING Tags associated with the organization field
title STRING The title of the organization field
type STRING The type of the organization field data
updated_at TIMESTAMP The date and time when the organization field was last updated
url STRING The URL associated with the organization field
_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.

  • organization_fields__custom_field_options (4 columns)
organization_memberships (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
default BOOL Flag indicating if this organization membership is the default one for the user.
url STRING The URL for accessing the details of this organization membership.
updated_at TIMESTAMP The date and time when the organization membership was last updated.
created_at TIMESTAMP The date and time when the organization membership was created.
id INT64 Unique identifier for the organization membership.
user_id INT64 The ID of the user associated with the organization membership.
organization_id INT64 The ID of the organization associated with the membership.
organization_name STRING The name of the organization associated with the membership.
view_tickets BOOL Flag indicating if the user can view tickets within the organization.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
organizations (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
group_id INT64 The ID of the group to which the organization belongs
created_at TIMESTAMP The date and time when the organization was created
shared_tickets BOOL Indicates if tickets are shared with this organization
notes STRING Any notes or comments related to the organization
shared_comments BOOL Indicates if comments are shared with this organization
details STRING Additional details about the organization
updated_at TIMESTAMP The date and time when the organization was last updated
name STRING The name of the organization
external_id STRING The external ID of the organization
url STRING The URL of the organization
id INT64 The unique ID of the organization
deleted_at TIMESTAMP The date and time when the organization was deleted
_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.

  • organizations__tags (4 columns)
  • organizations__domain_names (4 columns)
post_comment_votes (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at TIMESTAMP Timestamp when the vote was created
id INT64 Unique identifier for the vote
item_id INT64 Identifier of the item that was voted on
item_type STRING Type of the item that was voted on (e.g., ticket, article)
updated_at TIMESTAMP Timestamp when the vote was last updated
url STRING URL of the resource related to the vote
user_id INT64 Unique identifier of the user who voted
value INT64 Value of the vote (e.g., upvote, downvote)
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
post_comments (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
author_id INT64 The unique identifier of the author of the comment.
body STRING The content of the comment.
created_at TIMESTAMP The timestamp when the comment was created.
html_url STRING The URL to access the comment in HTML format.
id INT64 The unique identifier of the comment.
non_author_editor_id INT64 The unique identifier of the non-author editor of the comment.
non_author_updated_at TIMESTAMP The timestamp when the comment was last updated by a non-author editor.
official BOOL Indicates if the comment is from an official source.
post_id INT64 The unique identifier of the post to which the comment belongs.
updated_at TIMESTAMP The timestamp when the comment was last updated.
url STRING The URL to access the comment.
vote_count INT64 The total count of votes the comment has received.
vote_sum INT64 The sum of all votes (positive and negative) the comment has received.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
post_votes (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at TIMESTAMP Timestamp when the vote was created
id INT64 Unique identifier for the vote
item_id INT64 Identifier of the item that was voted on
item_type STRING Type of the item that was voted on (e.g., ticket, article)
updated_at TIMESTAMP Timestamp when the vote was last updated
url STRING URL of the resource related to the vote
user_id INT64 Unique identifier of the user who voted
value INT64 Value of the vote (e.g., upvote, downvote)
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
posts (23 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
author_id FLOAT64 The unique identifier of the author of the post.
closed BOOL Indicates whether the post is closed or open for further comments.
comment_count INT64 The total number of comments on the post.
details STRING Additional details or content of the post.
featured BOOL Indicates whether the post is featured or not.
follower_count INT64 The number of users following the post for updates.
frozen BOOL Indicates whether the post content is frozen or editable.
html_url STRING The URL that directs to the HTML version of the post.
id FLOAT64 The unique identifier of the post.
non_author_editor_id INT64 The unique identifier of a user who is not the author but edited the post.
non_author_updated_at TIMESTAMP The date and time when a non-author user last updated the post.
pinned BOOL Indicates if the post is pinned to stay on top of the list.
status STRING The current status of the post, such as ‘open’, ‘solved’, ‘archived’, etc.
title STRING The title or headline of the post.
topic_id INT64 The identifier of the topic under which the post belongs.
vote_count INT64 The total count of votes the post has received.
vote_sum INT64 The sum of all votes received considering both upvotes and downvotes.
created_at TIMESTAMP The date and time when the post was created.
url STRING The URL that points to the post details.
description STRING A brief summary or overview of the post content.
updated_at TIMESTAMP The date and time of the last update made to the post.
_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.

  • posts__content_tag_ids (4 columns)
satisfaction_ratings (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 The unique identifier of the satisfaction rating entry.
assignee_id INT64 The unique identifier of the user assigned to the ticket.
group_id INT64 The unique identifier of the group associated with the ticket.
reason_id INT64 The unique identifier of the selected satisfaction rating reason.
requester_id INT64 The unique identifier of the requester who provided the rating.
ticket_id INT64 The unique identifier of the ticket associated with the satisfaction rating.
updated_at TIMESTAMP The date and time when the satisfaction rating was last updated.
created_at TIMESTAMP The date and time when the satisfaction rating was created.
url STRING The URL to access the details of the satisfaction rating.
score STRING The satisfaction score given by the requester (usually a numeric value).
reason STRING The reason selected by the requester for the satisfaction rating.
comment STRING The feedback comment provided by the requester.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
schedules (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 The unique identifier for the schedule
name STRING The name of the schedule
time_zone STRING The time zone in which the schedule operates
created_at TIMESTAMP The date and time when the schedule was created
updated_at TIMESTAMP The date and time when the schedule was last updated
_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.

  • schedules__intervals (5 columns)
sections (16 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 Unique identifier for the section.
name STRING The name of the section.
category_id INT64 The id of the category to which this section belongs.
parent_section_id INT64 The id of the section to which this section belongs. Only writable for Guide Enterprise customers.
position INT64 The position of this section in the section list.
description STRING The description of the section.
locale STRING The locale where the section is displayed.
url STRING The API url of this section.
html_url STRING The url of this section in Help Center.
source_locale STRING The source (default) locale of the section.
theme_template STRING The theme template name used to display this section in Help Center.
outdated STRING Whether the section is out of date.
created_at TIMESTAMP The time at which the section was created.
updated_at TIMESTAMP The time at which the section was last updated.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
sla_policies (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 The unique identifier for the SLA policy.
url STRING The URL link to access the SLA policy details.
title STRING The title of the SLA policy.
description STRING The description of the SLA policy.
position INT64 The position of the SLA policy.
created_at TIMESTAMP The timestamp for when the SLA policy was created.
updated_at TIMESTAMP The timestamp for when the SLA policy was last updated.
_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.

  • sla_policies__filter__all (6 columns)
  • sla_policies__filter__any (6 columns)
  • sla_policies__policy_metrics (7 columns)
tags (4 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
count INT64 The number of tags associated with the fetched data.
name STRING The name of the tag associated with the fetched data.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
ticket_activities (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
actor__id INT64
actor__name STRING
actor_id INT64 The id of the user responsible for the ticket activity. An actor_id of -1 is a Zendesk system user, such as an automations action.
created_at TIMESTAMP When the record was created
description STRING Description of the activity
id INT64 Automatically assigned on creation
title STRING Description of the activity
updated_at TIMESTAMP When the record was last updated
url STRING The API url of the activity
user_id INT64 The id of the agent making the request
verb STRING The type of activity. Can be “tickets.assignment”, “tickets.comment”, or “tickets.priority_increase”
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
ticket_audits (49 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
author_id INT64 ID of the author of the ticket audit
metadata__suspension_type_id INT64 ID of the suspension type associated with the audit
metadata__trusted BOOL Indicates the trust level of the audit
metadata__decoration__channels__allow_channelback BOOL Indicates if channelback is allowed for the audit
metadata__decoration__source__id STRING ID of the source
metadata__decoration__source__name STRING Name of the source
metadata__decoration__source__zendesk_id INT64 Zendesk ID associated with the source
metadata__decoration__created_at STRING Date and time when the audit was created
metadata__decoration__external_id STRING External ID associated with the audit
metadata__decoration__resource_type STRING Type of resource associated with the audit
metadata__decoration__type STRING Type of decoration for the audit
metadata__decoration__version INT64 Version of the audit
metadata__flags_options___2__trusted BOOL Indicates the trust level of flag option 2
metadata__flags_options___11__trusted BOOL Indicates the trust level of flag option 11
metadata__flags_options___11__message__user STRING User associated with the message
metadata__flags_options___15__trusted BOOL Indicates the trust level of flag option 15
metadata__flags_options___15__message__user STRING User associated with the message
metadata__system__location STRING Location details associated with the system
metadata__system__longitude FLOAT64 Longitude of the location associated with the system
metadata__system__message_id STRING Message ID associated with the system
metadata__system__raw_email_identifier STRING Raw email identifier associated with the system
metadata__system__ip_address STRING IP address associated with the system
metadata__system__json_email_identifier STRING JSON email identifier associated with the system
metadata__system__client STRING Client associated with the system
… and 24 more columns

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

  • ticket_audits__events (55 columns)
  • ticket_audits__events__attachments (16 columns)
  • ticket_audits__events__attachments__thumbnails (13 columns)
  • ticket_audits__events__current_followers (4 columns)
  • ticket_audits__events__previous_followers (4 columns)
  • ticket_audits__events__via__source__from__original_recipients (4 columns)
  • ticket_audits__events__recipients (4 columns)
  • ticket_audits__metadata__notifications_suppressed_for (4 columns)
  • ticket_audits__metadata__flags (4 columns)
  • ticket_audits__via__source__from__ticket_ids (4 columns)
  • ticket_audits__via__source__from__original_recipients (4 columns)
  • ticket_audits__attachments (16 columns)
  • ticket_audits__attachments__thumbnails (3 columns)
ticket_comments (39 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at TIMESTAMP Timestamp indicating when the ticket comment was created.
timestamp INT64 UNIX timestamp representing the time the ticket comment was created.
body STRING Text body of the ticket comment.
id INT64 Unique identifier for the ticket comment.
ticket_id INT64 Identifier of the ticket to which the comment belongs.
event_type STRING Type of event associated with the ticket comment.
type STRING Type of the ticket comment.
via_reference_id INT64 Reference ID associated with the channel through which the ticket comment was created.
html_body STRING HTML formatted body of the ticket comment.
plain_body STRING Plain text version of the ticket comment body.
public BOOL Flag indicating if the ticket comment is public or private.
audit_id INT64 Unique identifier for the audit associated with this ticket comment.
author_id INT64 Identifier of the author of the ticket comment.
via__channel STRING
via__source__from__subject STRING
via__source__from__channel STRING
via__source__from__name STRING
via__source__from__address STRING
via__source__from__id INT64
via__source__from__ticket_id INT64
via__source__from__deleted BOOL
via__source__from__title STRING
via__source__to__name STRING
via__source__to__address STRING
… and 14 more columns

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

  • ticket_comments__via__source__from__ticket_ids (4 columns)
  • ticket_comments__via__source__from__original_recipients (4 columns)
  • ticket_comments__metadata__notifications_suppressed_for (4 columns)
  • ticket_comments__metadata__flags (4 columns)
  • ticket_comments__attachments (16 columns)
  • ticket_comments__attachments__thumbnails (13 columns)
  • ticket_comments__uploads (4 columns)
ticket_fields (26 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at TIMESTAMP The date and time when the ticket field was created.
title_in_portal STRING The title of the ticket field visible in the portal.
visible_in_portal BOOL Indicates whether the ticket field is visible in the portal or not.
collapsed_for_agents BOOL Specifies if the ticket field is collapsed for agents.
regexp_for_validation STRING Regular expression for validation of the ticket field value.
title STRING The title of the ticket field.
position INT64 Position of the ticket field.
type STRING Type of the ticket field.
editable_in_portal BOOL Indicates whether the ticket field is editable in the portal or not.
raw_title_in_portal STRING The raw title of the ticket field visible in the portal.
raw_description STRING The raw description of the ticket field.
updated_at TIMESTAMP The date and time when the ticket field was last updated.
tag STRING Tag associated with the ticket field.
removable BOOL Specifies if the ticket field is removable.
active BOOL Indicates whether the ticket field is active or not.
url STRING URL of the ticket field.
raw_title STRING The raw title of the ticket field.
required BOOL Indicates if the ticket field is required.
id INT64 The unique identifier of the ticket field.
description STRING Description of the ticket field.
agent_description STRING The description of the ticket field visible to agents.
required_in_portal BOOL Specifies if the ticket field is required in the portal.
key STRING Key associated with the ticket field.
sub_type_id INT64 The subtype identifier of the ticket field.
… and 1 more columns

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

  • ticket_fields__custom_field_options (8 columns)
  • ticket_fields__system_field_options (4 columns)
  • ticket_fields__custom_statuses (4 columns)
ticket_forms (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at TIMESTAMP The date and time when the ticket form was created.
name STRING The name of the ticket form.
display_name STRING The display name of the ticket form.
raw_display_name STRING The raw display name of the ticket form.
position INT64 The order position of the ticket form within a list.
raw_name STRING The raw name of the ticket form.
updated_at TIMESTAMP The date and time when the ticket form was last updated.
active BOOL Indicates if the ticket form is currently active.
default BOOL Indicates if the ticket form is the default form.
in_all_brands BOOL Indicates if the ticket form is available in all brands.
end_user_visible BOOL Indicates if the ticket form is visible to end users.
url STRING The URL to access the ticket form.
id INT64 Unique identifier for the ticket form.
_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.

  • ticket_forms__agent_conditions (4 columns)
  • ticket_forms__end_user_conditions (4 columns)
  • ticket_forms__restricted_brand_ids (4 columns)
  • ticket_forms__ticket_field_ids (4 columns)
ticket_metric_events (21 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
metric STRING Type of metric being tracked for the ticket
id INT64 Unique identifier for the ticket metric event
time STRING Timestamp when the metric event occurred
instance_id INT64 Unique identifier for the specific instance of the metric event
ticket_id INT64 Unique identifier for the ticket associated with the metric event
type STRING Type of metric event (e.g., update, change, escalation)
sla__policy__id INT64 Unique identifier for the SLA policy
sla__policy__title STRING Title of the SLA policy
sla__policy__description STRING Description of the SLA policy
sla__target INT64 Target time in minutes for the SLA
sla__business_hours BOOL Whether the SLA target uses business hours
group_sla__policy__id INT64 Unique identifier for the Group SLA policy
group_sla__policy__title STRING Title of the Group SLA policy
group_sla__policy__description STRING Description of the Group SLA policy
group_sla__target INT64 Target time in minutes for the Group SLA
group_sla__business_hours BOOL Whether the Group SLA target uses business hours
status__calendar INT64 Minutes the metric has been open in calendar hours
status__business INT64 Minutes the metric has been open in business hours
deleted BOOL Available if type is “breach”. In general, any branch event can be ignored when deleted is true
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
ticket_metrics (41 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
metric STRING Ticket metrics data
id INT64 Unique identifier for the ticket
time STRING Time related to the ticket
instance_id INT64 ID of the Zendesk instance associated with the ticket
ticket_id INT64 ID of the ticket
status__calendar INT64 The status of the ticket in calendar hours
status__business INT64 The status of the ticket in business hours
type STRING Type of ticket
agent_wait_time_in_minutes__calendar INT64 Time spent waiting for an agent to respond in calendar hours
agent_wait_time_in_minutes__business INT64 Time spent waiting for an agent to respond in business hours
assignee_stations INT64 Number of stations assigned to the ticket’s assignee
created_at TIMESTAMP Timestamp when the ticket was created
first_resolution_time_in_minutes__calendar INT64 Time taken to provide the first resolution in calendar hours
first_resolution_time_in_minutes__business INT64 Time taken to provide the first resolution in business hours
full_resolution_time_in_minutes__calendar INT64 Total time taken to fully resolve the ticket in calendar hours
full_resolution_time_in_minutes__business INT64 Total time taken to fully resolve the ticket in business hours
group_stations INT64 Number of stations assigned to the ticket’s group
latest_comment_added_at TIMESTAMP Timestamp when the latest comment was added
on_hold_time_in_minutes__calendar INT64 Total time the ticket was on hold in calendar hours
on_hold_time_in_minutes__business INT64 Total time the ticket was on hold in business hours
reopens INT64 Number of times the ticket has been reopened
replies INT64 Number of replies made on the ticket
reply_time_in_minutes__calendar INT64 Average time taken to reply to the ticket in calendar hours
reply_time_in_minutes__business INT64 Average time taken to reply to the ticket in business hours
… and 16 more columns
ticket_skips (77 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at TIMESTAMP The timestamp when the ticket skip entry was created
id INT64 Unique identifier for the ticket skip entry
reason STRING The reason for skipping the ticket
ticket_id INT64 The unique identifier of the skipped ticket
updated_at TIMESTAMP The timestamp when the ticket skip entry was last updated
user_id INT64 The unique identifier of the user who skipped the ticket
ticket__organization_id INT64
ticket__requester_id INT64
ticket__problem_id INT64
ticket__is_public BOOL
ticket__description STRING
ticket__submitter_id INT64
ticket__generated_timestamp INT64
ticket__brand_id INT64
ticket__id INT64
ticket__group_id INT64
ticket__type STRING
ticket__recipient STRING
ticket__has_incidents BOOL
ticket__created_at TIMESTAMP
ticket__raw_subject STRING
ticket__status STRING
ticket__updated_at TIMESTAMP
ticket__url STRING
… and 52 more columns

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

  • ticket_skips__ticket__follower_ids (4 columns)
  • ticket_skips__ticket__collaborator_ids (4 columns)
  • ticket_skips__ticket__tags (4 columns)
  • ticket_skips__ticket__fields (5 columns)
  • ticket_skips__ticket__custom_fields (5 columns)
  • ticket_skips__ticket__followup_ids (4 columns)
  • ticket_skips__ticket__via__source__from__original_recipients (4 columns)
  • ticket_skips__ticket__sharing_agreement_ids (4 columns)
  • ticket_skips__ticket__email_cc_ids (4 columns)
tickets (72 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
organization_id INT64
requester_id INT64
problem_id INT64
is_public BOOL
description STRING
submitter_id INT64
generated_timestamp INT64
brand_id INT64
id INT64
group_id INT64
type STRING
recipient STRING
has_incidents BOOL
created_at TIMESTAMP
raw_subject STRING
status STRING
updated_at TIMESTAMP
url STRING
allow_channelback BOOL
allow_attachments BOOL
due_at TIMESTAMP
priority STRING
assignee_id INT64
subject STRING
… and 47 more columns

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

  • tickets__follower_ids (4 columns)
  • tickets__collaborator_ids (4 columns)
  • tickets__tags (4 columns)
  • tickets__fields (5 columns)
  • tickets__custom_fields (5 columns)
  • tickets__followup_ids (4 columns)
  • tickets__via__source__from__original_recipients (4 columns)
  • tickets__sharing_agreement_ids (4 columns)
  • tickets__email_cc_ids (4 columns)
topics (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
html_url STRING The URL of the topic in HTML format.
id FLOAT64 The unique identifier of the topic.
name STRING The name/title of the topic.
url STRING The URL of the topic in API format.
created_at TIMESTAMP The date and time when this topic was created.
community_id INT64 The unique identifier of the community to which this topic belongs.
updated_at TIMESTAMP The date and time when this topic was last updated.
description STRING The textual description of the topic.
manageable_by STRING The user or group who can manage this topic.
follower_count FLOAT64 The count of users following this topic.
position FLOAT64 The order position of this topic relative to others.
user_segment_id FLOAT64 The identifier of the user segment associated with this topic.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
triggers (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
active BOOL Whether the ticket trigger is active
category_id STRING The ID of the category the ticket trigger belongs to
created_at STRING The time the ticket trigger was created
default BOOL If true, the ticket trigger is a standard trigger
description STRING The description of the ticket trigger
id INT64 Automatically assigned when created
position INT64 Position of the ticket trigger, determines the order they will execute in
raw_title STRING The raw format of the title of the ticket trigger
title STRING The title of the ticket trigger
updated_at STRING The time of the last update of the ticket trigger
url STRING The url of the ticket trigger
_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.

  • triggers__actions (5 columns)
  • triggers__conditions__all (6 columns)
  • triggers__conditions__any (6 columns)
user_fields (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
active BOOL Flag indicating if the user field is currently active or not.
created_at TIMESTAMP Timestamp indicating when the user field was created.
description STRING Detailed description of the user field.
id FLOAT64 Unique identifier for the user field.
key STRING Unique key associated with the user field.
position FLOAT64 Position index of the user field in the user profile.
raw_description STRING Raw HTML content for the user field description.
raw_title STRING Raw HTML content for the user field title.
regexp_for_validation STRING Regular expression for validating the user field value.
system BOOL Flag indicating if the user field is a system default field or a custom field.
tag STRING Tag associated with the user field for categorization.
title STRING Title or name of the user field.
type STRING Data type of the user field value.
updated_at TIMESTAMP Timestamp indicating when the user field was last updated.
url STRING URL pointing to the user field’s endpoint for detailed information.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
user_identities (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
verified BOOL Indicates if the user identity is verified.
primary BOOL Indicates if the user identity is the user’s primary.
type STRING The type of user identity (e.g. email).
value STRING The user identity value.
user_id INT64 The ID of the user the identity belongs to.
id INT64 Unique identifier for the user identity.
created_at TIMESTAMP The datetime when the user identity was created.
updated_at TIMESTAMP The datetime when the user identity was updated.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
users (48 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
verified BOOL Indicates if the user’s account is verified.
role STRING The role or position of the user.
chat_only BOOL Specifies if the user can only participate in chat interactions.
role_type INT64 The type of role assigned to the user.
phone STRING The phone number associated with the user.
organization_id INT64 The ID of the organization the user belongs to.
details STRING Additional details or information about the user.
email STRING The email address associated with the user.
only_private_comments BOOL Indicates if the user can only create private comments.
signature STRING The user’s email signature.
restricted_agent BOOL Specifies if the user is a restricted agent.
moderator BOOL Specifies if the user has moderator privileges.
updated_at TIMESTAMP The datetime when the user account was last updated.
external_id STRING An external identifier for the user.
time_zone STRING The time zone of the user.
photo__width INT64 The width of the photo.
photo__url STRING The URL of the user’s profile photo.
photo__inline BOOL Specifies if the photo should be displayed inline.
photo__content_url STRING The URL to access the photo content.
photo__content_type STRING The content type of the photo.
photo__file_name STRING The file name of the photo.
photo__size INT64 The size of the photo.
photo__mapped_content_url STRING The mapped URL to access the photo content.
photo__id INT64 The ID of the photo.
… and 23 more columns

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

  • users__tags (4 columns)
  • users__photo__thumbnails (13 columns)

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

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

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

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

Track tickets by status, priority, and over time to monitor volume and trends.

Use sla_policies and schedules to measure SLA attainment and breaches.

Measure first response and resolution times to find where service slows down.

Join Zendesk tickets with order or product data in BigQuery to connect support to the customer journey.

Use Zendesk Support data in your AI and BI tools

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

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