This integration will allow you to connect with Zendesk Chat and start collecting your data.

Setting up the Zendesk Chat Integration

Setting up the Zendesk Chat pipeline is really simple. Firstly you need to log into your account on Blendo and select the Zendesk Chat icon for adding a pipeline.


On the first step of the setup, Blendo will ask you to insert your Zendesk Chat subdomain. After you have typed it you should click on “Connect with Zendesk Chat” in order to authenticate your pipeline.

You will be redirected to Zendesk Chat, where you will see a message that asks you to allow Blendo access your Zendesk Chat account. In that window you should click on “Allow”.

In the next step you will be asked if you want to use a prefix to your tables names that will be created in your database. In case you leave it blank, the tables will use the default names. Also you should choose the database schema that is going to contain all the relevant tables in your database.

Finally, select which Zendesk Chat resources you want to be synced. By default, all resources are selected. Click on each one you don’t need, to deselect it. When you are ready, click on the “Create” button. That’s it! Your pipeline is ready to receive data.

Your pipeline is just created. If you want to initiate the sync, you should click on the “Sync now” button on the right or wait for the sync to start at the time indicated.

Configuration of the pipeline

When selecting the pipeline, you can see some information about it. On the top right you can see the pipeline ID, the data warehouse that the data is synced to and the schema that it is using.

Below you can find three tabs:

The first tab that you can see while selecting your pipeline is the Status tab. There you can see if the pipeline is syncing at the moment and for how long or if it has stopped. Additionally, you can manually stop the pipeline. Moreover, you can see the details of the current or previous sync, specifically the status of each of the tables that are syncing, and how many records have synced.


The second tab is the Resources tab. There you can edit the resource selection for your pipeline by selecting or deselecting any of the resources.

The third tab is the Settings tab. There you can see the account information of your Zendesk Chat pipeline and you can either pick another account or re-authenticate the pipeline.

Under that, you can see the Destination configuration and you can edit the table prefix and the database schema that your tables end up to.

Blendo collects the data as soon as they arrive and will sync them to your data warehouse according to your pipeline’s schedule. The default behaviour is to do this once per hour, but you can configure it to run as often as once per 15 minutes or once per day, by clicking on “Reschedule” button. Additionally, next to the “Reschedule” button you can find the “Pause” button that pauses the pipeline and keeps it paused until you manually resume it.

On the bottom of the page you can see the button “Remove”. By clicking it you delete your pipeline. This action is irreversible.


Keep in mind that any changes that may be done to the pipeline will be valid starting from the following sync and on.

Zendesk Chat Data Model & Schema Information

Blendo will now connect to your Zendesk Chat data source. It will sync your historical data and all the future updates into your destination data warehouse. You will get analytics ready tables and syncs that make sure you will get recent and consistent data.


What Zendesk Chat data do I have available?

Blendo creates analytics ready tables with recent and consistent data. Bellow you may find a CSV with all the columns and fields in more detail.

Expected Zendesk Chat Data Model & Schema Information >>

Questions? Contact us!

in Connecting SaaS Data Sources