With DataFlow, you can move data into ThoughtSpot from most databases.

If your company maintains large sources of data externally, you can use ThoughtSpot DataFlow to easily ingest just the relevant information, and then query that data and use ThoughtSpot’s analysis and visualization features. And after you configure scheduled refresh, your analysis visuals are always current.

Key features of DataFlow

Native connectors

Native connectors
Support for dozens of the most common databases,
data warehouses, file sources, and applications.

Point and click

Visual guided experience.
No SQL or coding skills required.

Granular selection

Granular selection
Select only the table columns you want to load.
No need to move entire data sets.

Incremental data load

Load incremental data
Option to add only new data to existing tables.
Or you can overwrite existing tables completely.

Incremental data load

Data mapping
Flexibly map columns from the data source
to columns in ThoughtSpot’s in-memory data store.

Schedule sync

Sync scheduling
Define granular data sync schedules:
monthly, weekly, daily, down to hourly intervals.

TQL editor

TQL interface
Run custom commands in an embedded TQL editor.
Create database objects, specify conditions, and validate data.

Alerts and monitoring

Alerts and monitoring
Monitor data sync history, view execution logs,
and get alerts when problems must be addressed.


We recommend that you perform these tasks before sharing ThoughtSpot DataFlow access with your organization: