Load data from a web browser
Overview
Explains what the feature is or what its benefits are to the user or customer.
Feature
The simplest way to load data is to upload a CSV or Excel file from the ThoughtSpot Web interface. This method is recommended for small, one time data loads. Using this method, the data schema is created for you automatically.
Loading data from a Web browser requires your data to be in a CSV (comma separated values) or a native Excel file.
Any user who belongs to a group that has the privilege Has administration privileges or Can upload user data will be able to upload their own data from the browser.
CSV is a common format for transferring data between databases. Your ETL (extract, transform, load) process will typically generate CSV files. You can also create a CSV file from a Microsoft Excel spreadsheet by opening the spreadsheet in Excel, choosing Save As and selecting CSV.
ThoughtSpot supports a wide range of date and timestamp formats in the CSV file.Loading data through the Web browser is recommended for smaller tables (under 50MB) with simple relationships between them. If you are loading a fact table that joins to dimension tables, you must load the fact table first, and then the dimension tables. The joining key must be a single column of unique values in the dimension table. NULL values in the fact table will not be able to be joined.
Blank values in user uploaded CSV files are interpreted as NULL values. These include the values (case insensitive):
To load the CSV or Excel file into ThoughtSpot: