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.ioKaivo 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.
What is the Zendesk Support connector
Section titled “What is the Zendesk Support connector”Sync your Zendesk Support tickets and fields into BigQuery with Kaivo to analyse support performance alongside the rest of your data.
| Category | Customer Service |
|---|---|
| Authentication | API key |
| Setup | Self-service |
Getting started with the Zendesk Support connector
Section titled “Getting started with the Zendesk Support connector”- Sign up for Kaivo and create a workspace.
- Connect your Zendesk Support account.
- Choose which tables to sync.
- Wait for the initial sync to finish.
- Query your data in BigQuery or your favourite AI or BI tool.
Authenticating Zendesk Support
Section titled “Authenticating Zendesk Support”Authenticate with your Zendesk Support credentials. You provide:
| Field | Description |
|---|---|
| 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.
|
Configuring the Zendesk Support connector
Section titled “Configuring the Zendesk Support connector”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. |
Nested subtables
Section titled “Nested subtables”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. |
Nested subtables
Section titled “Nested subtables”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. |
Nested subtables
Section titled “Nested subtables”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. |
Nested subtables
Section titled “Nested subtables”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. |
Nested subtables
Section titled “Nested subtables”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. |
Nested subtables
Section titled “Nested subtables”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. |
Nested subtables
Section titled “Nested subtables”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. |
Nested subtables
Section titled “Nested subtables”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. |
Nested subtables
Section titled “Nested subtables”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. |
Nested subtables
Section titled “Nested subtables”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 |
Nested subtables
Section titled “Nested subtables”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 |
Nested subtables
Section titled “Nested subtables”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 |
Nested subtables
Section titled “Nested subtables”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. |
Nested subtables
Section titled “Nested subtables”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 |
Nested subtables
Section titled “Nested subtables”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 |
Nested subtables
Section titled “Nested subtables”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. |
Nested subtables
Section titled “Nested subtables”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 |
Nested subtables
Section titled “Nested subtables”Repeating fields are split into their own tables, listed here with their column counts.
users__tags(4 columns)users__photo__thumbnails(13 columns)
How the Zendesk Support sync works
Section titled “How the Zendesk Support sync works”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.
Frequently asked questions
Section titled “Frequently asked questions”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.
Can I sync only some tables or columns?
Section titled “Can I sync only some tables or columns?”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.
Common use cases for Zendesk Support data
Section titled “Common use cases for Zendesk Support data”Ticket trends
Section titled “Ticket trends”Track tickets by status, priority, and over time to monitor volume and trends.
SLA performance
Section titled “SLA performance”Use sla_policies and schedules to measure SLA attainment and breaches.
Resolution times
Section titled “Resolution times”Measure first response and resolution times to find where service slows down.
Support and customers together
Section titled “Support and customers together”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.
Claude
Section titled “Claude”Use Kaivo’s MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →
Power BI
Section titled “Power BI”Microsoft’s BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →
Data Studio
Section titled “Data Studio”Free Google BI tool with native BigQuery support. One-click connection to your Kaivo warehouse; great for SMB teams on Google Workspace. Setup guide →
Tableau
Section titled “Tableau”The premium analytics standard, with native BigQuery integration. Setup guide →
Google Sheets
Section titled “Google Sheets”Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →
Connect via Power Query’s BigQuery connector. Setup guide →
Metabase
Section titled “Metabase”Open-source BI tool with strong BigQuery support. Setup guide →
See our pricing page for Zendesk Support connector pricing and plan details.