Data sources

Use the Data tab to manage data sources.

The Data tab lists all of the tables and data sources available to you. There are three types of data sources that you may see in the data list. They are tables, worksheets, and user-uploaded data. You usually see only worksheets and user-uploaded sources. These are the most commonly used data sources for searching.

Name Definition Created by

Table

Raw table loaded by an Administrator

Administrators

Worksheet

Collection of related tables optimized for searching (like standard concept of a view)

Anyone

User Imported

Table uploaded by a user through the web browser, such as a .csv file.

Anyone

View

Table saved as a materialized view by a user through the web browser through Save as view option on a search

Anyone

Clicking the name of a table or data source shows you detailed information about it. You won’t be able to change these settings or edit the table unless it was shared with you with the Edit privilege. To see how to edit a data source, refer to the ThoughtSpot Administrator Guide.

Use the filters at the top of the page to find the data you are interested in. From the Data tab, you can also delete or apply tags to tables and data sources in bulk by selecting them and clicking the appropriate action button.

manage data page

Data connections

The Data tab also contains information about your data connections.

Connections

If your company sources data from external warehouses, your connections appear under the Connections tab.

DataFlow

Your company may also load data directly to ThoughtSpot using DataFlow.

Other methods of data loading include the tsload command-line utility, and JDBC or ODBC drivers. For more information on data loading and caching strategies, see Data Use Strategies.


Related information