Zendesk Help Center
id 🔑�schedule_id 🔑 ➤ SCHEDULE�end_date�name�start_date
SCHEDULE_HOLIDAY ⇱
Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
Tags provide additional context about tickets, organizations and users and are used in automations.
Ticket comments, tag and field history are the central fact tables of Zendesk.
ticket_id 🔑 ➤ TICKET�tag 🔑
updated 🔑
user_id ➤ USER
tagged
via_*
TICKET_TAG_HISTORY ⇱
field_name 🔑 ➤ TICKET_CUSTOM_FIELD.id
ticket_id 🔑 ➤ TICKET�updated 🔑
user_id ➤ USER
value
via_*
TICKET_FIELD_HISTORY ⇱
id 🔑
ticket_id ➤ TICKET
user_id ➤ USER
body�call_id
created
facebook_comment�location
metadata
plain_body
public�recording_url�trusted
tweet
tweet_direct_message
voice_comment�voice_comment_call_duration
voice_comment_from
voice_comment_started
voice_comment_to
voice_comment_transcription_status
voice_comment_transcription_text
voice_comment_transcription_visible
via_*
TICKET_COMMENT ⇱
id 🔑
active
brand_url
default
has_help_center�help_center_state�logo_*
name
subdomain
url
BRAND ⇱
id 🔑
assignee_id ➤ USER
rater_id ➤ USER
ticket_id ➤ TICKET�group_id ➤ GROUP�comment�created
reason
score
updated�url
SATISFACTION_RATING ⇱
user_id 🔑 ➤ USER
tag 🔑
USER_TAG ⇱
ticket_id 🔑 ➤ ticket
tag🔑
TICKET_TAG ⇱
id 🔑
custom_role_id ➤ CUSTOM_ROLE
organization_id ➤ ORGANIZATION�default_group_id ➤ GROUP
active
alias�authenticity_token
chat_only
created
details
external_id
iana_time_zone
last_login
locale�locale_id
moderator
name
notes
only_private_comments
phone�remote_photo_url
report_csv
restricted_agent
role
role_type
shared�shared_agent
shared_phone_number�signature
suspended
ticket_restriction
time_zone
two_factor_auth_enabled
updated
verified
custom_*�url
USER ⇱
id 🔑
assignee_id ➤ USER�brand_id ➤ BRAND
forum_topic_id ➤ FORUM_TOPIC
organization_id ➤ ORGANIZATION
requester_id ➤ USER
submitter_id ➤ USER�group_id ➤ GROUP�custom_status_id ➤ TICKET_CUSTOM_STATUS
allow_channelback
allow_attachments
created_at
description
due
external_id
followup_ids
from_messaging_channel
has_incidents
priority
public�problem_id
raw_subject
recipient
status_
subject
ticket_form_id
type
updated_at
via_channel
via_followup_source_id
via_source_*
custom_*
merged_ticket_ids
url
TICKET ⇱
ticket_id 🔑 ➤ TICKET
created_at 🔑
schedule_id ➤ SCHEDULE
TICKET_SCHEDULE ⇱
Information about working hours.
id 🔑
created_at
name
time_zone
start_time
end_time
SCHEDULE ⇱
Custom dropdown fields refer to this dimension table
value 🔑
id
ticket_custom_field_id ➤ TICKET_CUSTOM_FIELD
name
default_value
TICKET_FIELD_OPTION ⇱
SLA Policies are a Zendesk Professional or Enterprise feature
id 🔑
updated_at 🔑
title
description
position
created_at
id🔑
active
agent_description
collapsed_for_agents
created_at
description
editable_in_portal
key
position
raw_description
raw_title
raw_title_in_portal
regexp_for_validation
relationship_target_type
removable
required
required_in_portal
sub_type_id
system
tag
title
title_in_portal
type
updated_at
url
visible_in_portal
TICKET_CUSTOM_FIELD ⇱
field_id 🔑
ticket_id 🔑 ➤ TICKET
index🔑
value➤ TICKET_FIELD_OPTION.value
ticket_id 🔑 ➤ TICKET
sla_policy_id 🔑➤ SLA_POLICY_HISTORY
policy_applied_at
TICKET_SLA_POLICY
Schedule assignment for tickets is a Zendesk Enterprise feature. For all other accounts the default schedule applies to all tickets.
id 🔑
updated_at 🔑
author_id ➤ USER
topic_id ➤ FORUM_TOPIC
_fivetran_deleted
closed
comment_count
created_at
details
featured
follower_count
html_url
pinned
status
title
url
vote_count
vote_sum
POST ⇱
id 🔑
updated_at 🔑
author_id ➤ USER
post_id ➤ POST
body
created_at
html_url
official
url
vote_count
vote_sum
POST_COMMENT ⇱
id 🔑
updated_at 🔑
ticket_id ➤ TICKET
user_id ➤ USER
created_at�reason
SKIP_TICKET_HISTORY ⇱
TICKET_ATTRIBUTE ⇱
ticket_id 🔑 ➤ TICKET
attribute_name 🔑
value 🔑
TICKET_ALERT ⇱
id 🔑
ticket_id ➤ TICKET
user_id ➤ USER
body
created_at
resource
subject
type
via _*
ALERT_RECIPIENT⇱
ticket_alert_id 🔑 ➤ TICKET_ALERT
user_id 🔑 ➤ USER
TICKET_FORM_HISTORY ⇱
id 🔑
updated_at 🔑
active
created_at
display_name
default
end_user_visible
fivetran_delete
in_all_brands
name
position
raw_display_name
raw_name
url
TIME_ZONE
tz 🔑�standard_offset
TICKET_LINK ⇱
id 🔑
ticket_id ➤ TICKET
created_at
issue_id
issue_key
updated_at
TWEET_RECIPIENT ⇱
ticket_comment_id 🔑 ➤ TICKET_COMMENT
user_id 🔑 ➤ USER
TICKET_MACRO_REFERENCE ⇱
id 🔑
ticket_id ➤ TICKET
user_id ➤ USER
macro_id
macro_title
macro_deleted
via_*
id 🔑
user_id ➤ USER
item_id
item_type
value
created_at
updated_at
USER_VOTE ⇱
DAYLIGHT_TIME
time_zone 🔑�year 🔑�daylight_start_utc�daylight_end_utc�daylight_offset
id 🔑
group_id ➤ GROUP
user_id ➤ USER
GROUP_MEMBER ⇱
id 🔑
name
created
updated
url
GROUP ⇱
id 🔑
organization_id ➤ ORGANIZATION
user_id ➤ USER
ORGANIZATION_MEMBER ⇱
id 🔑
group_id ➤ GROUP
details
created
external_id
name
notes
shared_comments
shared_tickets�updated
custom_*
url
ORGANIZATION ⇱
organization_id 🔑
index 🔑
domain_name
DOMAIN_NAME ⇱
agent_id 🔑 ➤ USER
attribute_name 🔑
value 🔑
AGENT_ATTRIBUTE ⇱
id 🔑
actor_id ➤ user.id
action
change_description
created_at�source_id
source_label
source_type
AUDIT_LOG ⇱
id 🔑
description
name
configuration_*
role_type
created_at
updated_at
CUSTOM_ROLE ⇱
id 🔑
author_id ➤ user.id
permission_group_id ➤ group.id
user_segment_id➤ user_segment.id
body
comments_disabled
created_at
updated_at
edited_at
draft
url
html_url
position
vote_sum
vote_count
section_id
promoted
outdated
name
title
source_locale
locale
ARTICLE ⇱
organization_id 🔑 ➤ ORGANIZATION
tag
ORGANIZATION_TAG ⇱
Zendesk Talk
id 🔑
agent_id ➤ USER�ticket_id ➤ TICKET
call_charge
call_group_id
call_recording_consent
call_recording_consent_action
call_recording_consent_keypress
callback
callback_source
completion_status
consultation_time
created_at
customer_requested_voicemail
default_group
direction
duration
exceeded_queue_wait_time
hold_time
ivr_action
ivr_destination_group_name
ivr_hops
ivr_routed_to
ivr_time_spent
minutes_billed
not_recording_time
outside_business_hours
overflowed
overflowed_to
phone_number
phone_number_id
quality_issues
recording_control_interactions
recording_time
talk_time
time_to_answer
updated_at
voicemail
wait_time
wrap_up_time
CALL_METRIC ⇱
id 🔑
agent_id ➤ USER.id
call_id ➤ CALL_METRIC.id
user_id ➤ USER.id
available_via
call_charge
completion_status
conference_from
conference_time
conference_to
consulation_from
consulation_time
consulation_to
created_at
duration
forwarded_to
hold_time
minutes_billed
talk_time
transferred_from
transferred_to
type
updated_at
wrap_up_time
CALL_LEG ⇱
CALL_LEG_QUALITY_ISSUE
issue 🔑
call_leg_id 🔑➤ CALL_LEG.id
ADDRESS ⇱
id 🔑
city
country_code
name
provider_reference
province
state
street
zip
GREETING_CATEGORY ⇱
id 🔑
name
GREETING_IVR
ivr_id 🔑➤ IVR.id
greeting_id 🔑➤ GREETING.id
GREETING ⇱
id 🔑
category_id ➤ GREETING_CATEGORY.id
active
audio_name
audio_url
default_lang
has_sub_settings
name
Pending
system_default
upload_id
IVR ⇱
id 🔑
name
IVR_MENU ⇱
id 🔑
ivr_id 🔑➤ IVR
greeting_id ➤ GREETING�name
system_default
IVR_MENU_ROUTE ⇱
id 🔑
ivr_menu_id 🔑➤ IVR
action
greeting
keypress
option_text
options_*
id 🔑
brand_id ➤ BRAND�ivr_id ➤ IVR
schedule_id ➤ SCHEDULE
call_recording_conscent
capabilities_*
country_code
created_at
default_group_id
display_number
external
failover_number
line_type
location
name
nickname
number
outbound_enabled
outbound_number
priority
recorded
sms_enabled
sms_group_id
token
toll_free
transcription
voice_enabled
LINE ⇱
LINE_CATEGORISED_GREETING
category_id 🔑➤ GREETING_CATEGORY
line_id 🔑➤ LINE
greeting_id 🔑➤ GREETING
LINE_GREETING
line_id 🔑➤ LINE
greeting_id 🔑➤ GREETING
is_default
LINE_GROUP
line_id 🔑➤ LINE
group_id 🔑➤ GROUP
IVR_MENU_ROUTE_OPTION
ivr_menu_route_id 🔑➤ IVR_MENU_ROUTE.id
group_id 🔑➤ GROUP
ticket_id 🔑 ➤ TICKET
user_id 🔑 ➤ USER
TICKET_COLLABORATOR ⇱
ticket_id 🔑 ➤ TICKET
user_id 🔑 ➤ USER
TICKET_FOLLOWER ⇱
id 🔑
ticket_custom_field_id ➤ TICKET_CUSTOM_FIELD
active
default_value�agent_label�created_at�description�end_user_description�end_user_label�status_category�updated_at
TICKET_CUSTOM_STATUS ⇱
_fivetran_id 🔑
child_field_id ➤ TICKET_CUSTOM_FIELD
is_required
parent_field_id ➤ TICKET_CUSTOM_FIELD
parent_field_type
ticket_form_id ➤ TICKET_FORM_HISTORY.id
required_on_statuses_type
value
_fivetran_id🔑
agent_condition_id ➤ AGENT_CONDITION
status
TICKET_FORM_RESTRICTED_BRAND
_fivetran_id 🔑
child_field_id ➤ TICKET_CUSTOM_FIELD
is_required
parent_field_id ➤ TICKET_CUSTOM_FIELD
parent_field_type
ticket_form_id ➤ TICKET_FORM_HISTORY.id
type
ticket_form_id 🔑➤ TICKET_FORM_HISTORY.id
brand_id 🔑➤ BRAND
id🔑
ticket_comment_id ➤ TICKET_COMMENT
content_url
content_type
deleted
file_name
height
inline
malware_access_override
mapped_content_url
malware_scan_result
size
width
TICKET_COMMENT_ATTACHMENT ⇱
ticket_id 🔑 ➤ TICKET
user_id 🔑 ➤ USER
TICKET_EMAIL_CC ⇱
article_id 🔑 ➤ ARTICLE
content_tag_id ➤ CONTENT_TAG
ARTICLE_CONTENT_TAG ⇱
article_id 🔑 ➤ ARTICLE
label_name
ARTICLE_LABEL_NAME ⇱
article_id 🔑 ➤ ARTICLE
outdated_locale
ARTICLE_OUTDATED_LOCALE ⇱
content_tag_id 🔑
name
created_at
updated_at
CONTENT_TAG ⇱
_fivetran_id 🔑
side_conversation_event_id ➤ TICKET_SIDE_CONVERSATION�user_id ➤ USER�support_group_id ➤ GROUP�support_agent_id ➤ USER
msteams_channel_id
name
slack_channel_id
slack_workspace_id
TICKET_SIDE_CONVERSATION_RECIPIENT ⇱
id 🔑
ticket_id ➤ TICKET
created_at�state_updated_at
state
subject
TICKET_SIDE_CONVERSATION ⇱
id 🔑
side_conversation_id🔑
actor_user_id ➤ USER
actor_support_group_id ➤ GROUP
actor_support_agent_id ➤ USER
message_from_user_id ➤ USER
message_from_support_group_id ➤ GROUP
message_from_support_agent_id ➤ USER
actor_email
actor_msteams_channel_id
actor_name
actor_slack_channel_id
actor_slack_workspace_id
type�created_at
message_from_email
message_from_msteams_channel_id
message_from_name
message_from_slack_channel_id
message_from_slack_workspace_id
message_subject
message_preview_text
message_body
message_external_id_*
updated_state
updated_subject
via_*
TICKET_SIDE_CONVERSATION_EVENT ⇱
id 🔑
ticket_id ➤ TICKET�brand_id ➤ BRAND
author_id ➤ USER
author_name
author_email
cause
cause_id
content�created_at
message_id
recipient
subject
updated_at
url
via_*
SUSPENDED_TICKET ⇱
id🔑
suspended_ticket_id 🔑➤ SUSPENDED_TICKET
content_url
content_type
deleted
file_name
height
inline
malware_access_override
mapped_content_url
malware_scan_result
size
width
SUSPENDED_TICKET_ATTACHMENT ⇱
id 🔑
active
app_installation
created_at
default
description
permissions
position
restriction
title
updated_at
url
MACRO ⇱
id 🔑
active
app_installation
category_id
created_at
default
description
permissions
position
raw_title
title
updated_at
url
TRIGGER ⇱
id 🔑
active
app_installation
created_at
default
permissions
position
raw_title
title
updated_at
AUTOMATION ⇱
macro_id 🔑➤ MACRO
field 🔑
value
MACRO_ACTION ⇱
trigger_id 🔑➤ TRIGGER
_fivetran_id 🔑
condition_type
field
operator
value
TRIGGER_CONDITION ⇱
trigger_id 🔑➤ TRIGGER
field 🔑
value
TRIGGER_ACTION ⇱
automation_id 🔑➤ AUTOMATION
field 🔑
value
AUTOMATION_ACTION ⇱
automation_id 🔑➤ AUTOMATION
_fivetran_id 🔑
condition_type
field
operator
value
AUTOMATION_CONDITION ⇱
SLA Policies are a Zendesk Professional or Enterprise feature
group_sla_policy_id 🔑 ➤ GROUP_SLA_POLICY_HISTORY
metric 🔑
priority 🔑
business_hours
target
GROUP_SLA_POLICY_METRIC_HISTORY ⇱
id 🔑
created_at
description
position
title
updated_at
GROUP_SLA_POLICY_HISTORY ⇱
ticket_id 🔑 ➤ TICKET
group_sla_policy_id 🔑➤ SLA_POLICY_HISTORY
group_policy_applied_at
TICKET_GROUP_SLA_POLICY ⇱
sla_policy_id 🔑 ➤ SLA_POLICY_HISTORY.id
sla_policy_updated_at 🔑 ➤ SLA_POLICY_HISTORY.updated_at�index 🔑
priority
metric
target
business_hours
SLA_POLICY_METRIC_HISTORY ⇱
TICKET_FORM_RESTRICTED_BRAND
ticket_form_id 🔑➤ TICKET_FORM_HISTORY.id
brand_id 🔑➤ BRAND
created_at 🔑
chat_id 🔑➤ TICKET_CHAT
actor_id ➤ USER
chat_index
external_message_id
filename
is_history_context
message
message_id
message_source
mime_type
original_message
original_message_type
parent_message_id
reason
size
status
status_updated_at
type
url
TICKET_CHAT_EVENT ⇱
chat_id 🔑
ticket_id ➤ TICKET
user_id ➤ USER
authenticated
backend
channel
conversation_id
initiator
integration_id
visitor_id
tags
webpath
TICKET_CHAT ⇱
id 🔑
updated_at
non_author_updated_at
author_id ➤ USER
non_author_editor_id ➤ USER
source_id ➤ ARTICLE
body
created_at
html_url
official
url
vote_count
vote_sum
ARTICLE_COMMENT ⇱
id 🔑
created_at
description
html_url�locale�name�outdated�position�source_locale�updated_at�url
CATEGORY ⇱
id 🔑
category_id ➤ CATEGORY
created_at
description�html_url�locale�name�outdated�parent_section_id�position�source_locale
sorting
theme_template
updated_at
url
SECTION ⇱
id 🔑
built_in
created_at
name�updated_at�user_type
USER_SEGMENT ⇱
user_segment_id 🔑 ➤ USER_SEGMENT
organization_id 🔑 ➤ ORGANIZATION
USER_SEGMENT_ORGANIZATION
user_segment_id 🔑 ➤ USER_SEGMENT
tag 🔑
is_or_tag🔑
USER_SEGMENT_TAG
user_segment_id 🔑 ➤ USER_SEGMENT
user_id 🔑 ➤ USER
USER_SEGMENT_ADDED_USER
id 🔑
user_segment_id➤USER_SEGMENT�created_at�description
follower_count�html_url�manageable_by�name�updated_at
url
FORUM_TOPIC ⇱
AGENT_CHANNEL_HISTORY ⇱
agent_id 🔑 ➤ USER�channel 🔑
updated_at
AGENT_STATUS_HISTORY⇱
agent_id 🔑 ➤ USER
channel 🔑
updated_at�previous_status
new_status
AGENT_UNIFIED_STATUS_HISTORY⇱
agent_id 🔑➤ USER
updated_at�previous_id ➤ AGENT_STATUS_TYPE
new_id ➤ AGENT_STATUS_TYPE
previous_reason
new_reason
agent_id 🔑➤ USER�channel 🔑
updated_at�previous
current
AGENT_MAX_CAPACITY_HISTORY⇱
AGENT_STATUS_TYPE⇱
id 🔑�channels_messaging�channels_support�channels_talk
description
name
updated_at
AGENT_STATUS_TYPE_GROUP⇱
agent_status_type_id 🔑➤ AGENT_STATUS_TYPE�group_id 🔑➤ GROUP
ticket_id 🔑 ➤ TICKET
survey_response_id 🔑
survey_id ➤ CSAT_SURVEY_QUESTION
survey_version ➤ CSAT_SURVEY_QUESTION
expires_at
survey_state
responder_id
subject_zrns
subjects
TICKET_CSAT_SURVEY ⇱
question_id 🔑 ➤ CSAT_SURVEY_QUESTION
survey_response_id 🔑 ➤ TICKET_CSAT_SURVEY
selections_option_id ➤ CSAT_SURVEY_CLOSED_ENDED_OPTION
rating ➤ CSAT_SURVEY_RATING_OPTION
type
value
created_at
updated_at
selections_type
rating_category
CSAT_SURVEY_ANSWER ⇱
survey_id 🔑
survey_version 🔑
question_id 🔑
type
alias
headline_type
headline_value
headline_key
sub_type
CSAT_SURVEY_QUESTION ⇱
survey_id 🔑➤ CSAT_SURVEY_QUESTION
survey_version 🔑➤ CSAT_SURVEY_QUESTION
question_id 🔑➤ CSAT_SURVEY_QUESTION
rating 🔑
label_type
label_value
label_key
emoji_type
emoji_value
CSAT_SURVEY_RATING_OPTION ⇱
survey_id 🔑 ➤ CSAT_SURVEY_QUESTION
survey_version 🔑 ➤ CSAT_SURVEY_QUESTION
question_id 🔑 ➤ CSAT_SURVEY_QUESTION
option_id 🔑
label_type
label_value
label_key
CSAT_SURVEY_CLOSED_ENDED_OPTION⇱
id 🔑
updated_at🔑
url
locale
name
native_name
presentation_name
rtl
created_at
default
LOCALE ⇱
id 🔑
user_id ➤ USER
created_at�deliverable_state�is_primary�type
undeliverable_count
updated_at�url�value�verified�verification_method�verified_at
USER_IDENTITY ⇱
Notable data not included:
id 🔑
badge_category_id ➤ BADGE_CATEGORY
user_id ➤ USER
created_at
description
icon_url
name
updated_at
BADGE ⇱
id 🔑
brand_id
created_at
name
slug
updated_at
BADGE_CATEGORY ⇱
id 🔑
badge_id ➤ BADGE
user_id ➤ USER
created_id
BADGE_ASSIGNMENT ⇱
content_id refers to the ID of an Article, Post, Topic, or Section�content_type is either Article, Post, Topic, or Section
id 🔑
user_id ➤ USER
content_id
content_type
created_at
updated_at
include_comments
locale
source_locale
url
CONTENT_SUBSCRIPTION⇱
Zendesk__ticket_metrics and other models must be created using Transformations
ticket_id 🔑 ➤ TICKET
_*
ZENDESK__TICKET_METRICS ⇱
id 🔑
follower_id ➤ USER
followed_id ➤ USER
USER_SUBSCRIPTION ⇱
Translation Will only be synced if any one of the entity Article, Section or Categories is selected.��If you stop syncing translation data and start re-syncing it later, the connection will not backfill missing translation records for already synced articles, sections, and categories.
�
id 🔑
source_id
source_type
locale
title
body
outdated
draft
hidden
created_at
updated_at
created_by_id
updated_by_id
url
html_url
Translation ⇱