How to load data from Zendesk Talk to Data Warehouse

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

Setting up the Zendesk Talk Integration

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

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

You will be redirected to Zendesk Talk, where you will see a message that asks you to allow Blendo access your Zendesk Talk 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 Talk 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 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.

What Zendesk Talk data do I have available?

Bellow are some of the tables with Zendesk Talk data that we create in your target data warehouse.

Expected Zendesk Talk Data Model & Schema Information

For a complete view of the data model of your expected data click here.

Questions? Contact us!


in Connecting SaaS Data Sources