Zendesk Support is a cloud-based customer support platform.
|Custom Data||check||We support custom fields for the
We support the custom table
We do not support Zendesk custom objects.
|dbt Package||check||Get the package: source / transform|
We capture deletes in the
TICKET_FIELD_HISTORYtables using the
|Zendesk Chat||Using our Zendesk Chat connector|
|Zendesk Gather||Only Posts and Comments|
|Zendesk Guide||Only Articles|
|Zendesk Talk||Only Call Metrics|
Follow our step-by-step Zendesk Support setup guide to connect Zendesk Support with your destination using Fivetran connectors.
This schema applies to all Zendesk Support connections created after 12/7/2017.
To display some information about ticket deletion, we artificially create a
TICKET_FIELD_HISTORY record when we detect a deleted ticket - it is not created from any audit event. This is because the source does not provide us event audit data for deleted tickets. Any ticket audit event indicating deletion of a ticket is added with a
null value in the
user_id column, and the
updated_at value is taken from the
updated_at value on the ticket that was deleted.
TICKET_FIELD_HISTORY.field_name is the custom field ID for custom fields. The
TICKET_CUSTOM_FIELD table contains the custom field title.
Schedule assignment for tickets is a Zendesk Enterprise feature. For all other accounts the default schedule applies to all tickets.
We sync the
SCHEDULE table only if you have created a schedule in Zendesk.
We sync the
TICKET_SCHEDULE table when you create a trigger with a set schedule action. Read Zendesk’s documentation for more information.
We exclude the
ORGANIZATION_MEMBERSHIP table from the sync by default because it can be a large table and may degrade performance. We also exclude the
AUDIT_LOG table from the sync by default. If you wish to sync these tables go to the Schema tab of your Fivetran dashboard and select the tables.
The Zendesk Support connector supports multithreading. Fivetran uses multiple parallel API requests to sync data from Zendesk systems to your destination. The connector’s sync speed depends on your Zendesk API quota.
Syncing empty tables and columnslink
The Zendesk Support connector doesn’t support the creation of empty tables and columns in your destination.
We create a table in the destination only if we can retrieve the table data from the source. If Zendesk doesn’t return data for the source table, we don’t create the table in your destination.