ThoughtSpot Sync

You can now sync data directly from an answer or a custom SQL view, to an external business app. Using ThoughtSpot Sync, you can push insights directly to your app, notify your teams, and view data in context. ThoughtSpot automatically establishes a secure pipeline to the destination app and thus eliminates the need for building custom connectors to external apps. You can quickly get started and push data to your workspace with a few simple steps.

ThoughtSpot Sync homepage

From the Data Workspace, you can access ThoughtSpot Sync to view and create new destinations, manage pipelines, and view sync activity for your team. To navigate to the ThoughtSpot Sync page, click on the Data tab and select Sync from the menu on the left.

Only users with admin privileges see the syncs and pipelines created by other users in their group. Users without admin privileges see only the syncs and pipelines they personally create.

Destinations

From the Destinations tab, you can add a new destination and view existing destinations created by your team. A destination defines the business app you connect to and the authorized user creating the connection. To create a new destination, select the tile with the name of the external app you want to sync to.

To edit, reauthorize, or delete a pipeline, scroll through the destinations list and select the more options menu icon icon more 10px to the left of the pipeline author name. Note that existing pipelines may break when you reauthorize the destination.

ts sync destinations

Pipelines

A pipeline defines the data sent to a specific destination from an answer or view. To create a new pipeline from the Pipelines tab, select the Create new pipeline button.

To edit, delete, sync immediately, or view run history of a certain pipeline, find the pipeline name in the list and select the more options menu icon icon more 10px to the right of the pipeline Frequency. You can use the Sources and Destinations fields to the left of the search bar to filter through the list, or search by name in the search bar.

ts sync pipelines

Note that when you create a new pipeline, you can use the icons displayed in the Source drop-down to determine the format of your source. Answers are shown with a pie-chart icon, while SQL views display a SQL icon, and Sage views display an article icon.

ts sync new pipeline

Activity

Use the Activity tab to view the run history of all pipelines. You can see the pipeline source type, run type, start and end time, number of rows sent, sync status, and activity log. Click Activity log to see more information about the sync’s run, or to download the log file.

ts sync activity

Sync to an external application

For more information on sending data from ThoughtSpot to specific external applications, see: