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.
Legend
π = primary key
β€ = foreign key relation
β± = external link
Notable data not included:
If you believe that data you need is missing, please contact support@fivetran.com
ticket_id π β€ TICKETοΏ½tag π
updated π
user_id β€ USER
tagged
TICKET_TAG_HISTORY β±
field_name πβ€ TICKET_CUSTOM_FIELD.id
ticket_id π β€ TICKETοΏ½updated π
user_id β€ USER
value
TICKET_FIELD_HISTORY β±
id π
ticket_id β€ TICKET
user_id β€ USER
body
created
facebook_comment
public
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
TICKET_COMMENT β±
ticket_comment_id π β€ TICKET_COMMENT
user_id π β€ USER
TWEET_RECIPIENT β±
id π
active
brand_url
default
has_help_centerοΏ½help_center_stateοΏ½logo_*
name
subdomain
BRAND β±
id π
description
name
FORUM_TOPIC β±
id π
assignee_id β€ USER
rater_id β€ USER
ticket_id β€ TICKETοΏ½commentοΏ½created
reason
score
updated
SATISFACTION_RATING β±
id π
description
name
configuration_*
CUSTOM_ROLE β±
id π
group_id β€ GROUP
user_id β€ USER
GROUP_MEMBER β±
id π
name
created
deleted
updated
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_*
ORGANIZATION β±
organization_id π β€ ORGANIZATION
tag
ORGANIZATION_TAG β±
user_id π β€ USER
tag
USER_TAG β±
ticket_id π β€ ticket
tag
TICKET_TAG β±
id π
custom_role_id β€ CUSTOM_ROLE
default_group_id β€ GROUP
organization_id β€ ORGANIZATION
active
alias
chat_only
created
details
external_id
last_login
locale
moderator
name
notes
only_private_comments
phone
restricted_agent
role
shared
suspended
ticket_restriction
time_zone
two_factor_auth_enabled
updated
verified
custom_*
USER β±
id π
assignee_id β€ USERοΏ½brand_id β€ BRAND
follow_up_of_id β€ TICKET
forum_topic_id β€ FORUM_TOPIC
organization_id β€ ORGANIZATION
problem_id β€ TICKET
requester_id β€ USER
submitter_id β€ USER
created_at
description
due
external_id
priority
public
recipient
status
subject
type
updated_at
via_channel
custom_*
TICKET β±
organization_id π
index π
domain_name
DOMAIN_NAME β±
ticket_id π β€ TICKET
created_at π
schedule_id β€ SCHEDULE
TICKET_SCHEDULE
Information about working hours.
id π
name
time_zone
start_time
end_time
start_time_utc
end_time_utc
SCHEDULE β±
Custom dropdown fields refer to this dimension table
id π "value" in Zendesk API
name
TICKET_FIELD_OPTION β±
SLA Policies are a Zendesk Professional or Enterprise feature
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 β±
id π
updated_at π
title
description
position
created_at
id π
title
TICKET_CUSTOM_FIELD β±
field_idπ β€ TICKET_CUSTOM_FIELD.id
ticket_idπ β€ TICKET
indexπ
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.