Explains what the feature is or what its benefits are to the user or customer.
There are several methods of loading data into ThoughtSpot. This section describes each method and why you might choose it above the others.
The fastest and easiest way to load a new table is by importing it using the Web browser. This is best for one time data loads of small tables which do not have complex relationships to other tables. This method is limited to tables that are under 50 MB (megabytes) in size.
Using ThoughtSpot Loader, you can script recurring loads and work with multi-table schemas.
If your data already exists in another database with the schema you want to use in ThoughtSpot, you can pull the schema and data in using the ODBC or JDBC driver.
These are the methods you can use to load data, along with the benefits of each method:
Make use of an established ETL process and tool(s).
Connect to ThoughtSpot using third party tools like SSIS.
You don't need to define a schema to accept the data load.
Use the Informatica Connector
Use the Informatica Connector if you already use Informatica to connect to your other data sources.
Works with your established data migration processes in Informatica.
If you're uploading data through the Web interface, you can use a native Excel file. If you want to use a CSV (comma separated values) or delimited file, or you are loading using ThoughtSpot Loader, you'll need to Generate CSV Files with the Data to be Loaded first.
Load Data From a Web Browser
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.
Plan the Schema
Before you can load data with ThoughtSpot Loader, you must create a schema to receive it, using the SQL command line interface (TQL).
Build the Schema
Before you can load data into ThoughtSpot, you must build a database schema to receive it. You will do this by writing a SQL script, which creates the objects in your schema.
Change the Schema
After you've created a schema and loaded data, you may find yourself wishing you'd set things up a little differently. You can make changes to the schema, such as changing the primary key, relationships to other tables, and sharding.
Load Data with ThoughtSpot Loader ThoughtSpot Loader (tsload) is the most common way to import data. When using tsload, you can load larger datasets and make the loading process repeatable through scripting.