Load CSV files with the UI in Free Trial
| This feature is exclusive to ThoughtSpot Free Trial. Use Connections to access your data in ThoughtSpot Cloud. |
In ThoughtSpot’s free trial, you can upload your own data to perform live queries on it. You can connect to your cloud data warehouse, and you can upload 1 flat data file, or CSV.
Your data should be in a CSV (comma separated values) file before you load it. A CSV file is a text file made up of data fields separated by a delimiter and optionally enclosed with an enclosing character.
Add data files
Learn how to upload a CSV file. You can also edit that file later, or replace it with a different file. Note that you can only use 1 CSV file at a time.
Upload a flat data file (CSV)
To upload a CSV file, follow these steps:
-
Select Data in the top navigation bar.
-
Select Utilities in the side navigation bar.
-
Select Upload CSV.
Alternatively, navigate to step one of Setup, and select upload CSV.
-
Upload the CSV file using one of these options:
-
Click Browse your files and select the file.
-
Drag and drop the file into the drop area.
-
-
Answer the question Are the column names already defined in the file header?
Specify one of the following:
- Comma
-
(,), example:
Jacket,Winter 2021,yellow,600 - Semicolon
-
(;), example:
Jacket;Winter 2021;yellow;600 - Pipe
-
(|), example:
Jacket|Winter 2021|yellow|600 - Space
-
( ), example:
Jacket "Winter 2021" yellow 600 - Tab
-
( ), example:
Jacket Winter 2021 yellow 600
-
Select Next.
-
If column names are missing, select the column header to add column names that describe the attributes or measures in the columns.
You can also change existing names to a simpler or more human-readable format.
-
Select Next.
-
Review the automatically-generated data types for each column, and make necessary changes.
These are the possible data types:
- True/False
-
Boolean, Yes, no.
- Integer
-
Smaller integers represented by 32 bits.
- Large Integer
-
Larger integers represented by 64 bits.
- Decimal
-
Floating point or Decimal.
- Text
-
Character or text.
- Date
-
Simple date, not including the time component.
- Date_Time
-
The date and time.
- Time
-
Only the time, not including the date component.
-
Select Upload.
| Users have an upload limit of one CSV file. |
Replace or append new data to a CSV file
To replace your uploaded CSV file or append new data to it, follow these steps:
-
Select Data in the top navigation bar.
-
Select your current CSV file in the list of data sources.
-
Select Replace CSV in the upper-right corner of your screen.
-
Answer the question Are the column names already defined in the file header?
-
Answer the question Do you want to append to the existing data or overwrite it?
To add this data to your existing CSV file, choose Append. To create a new CSV file, choose Overwrite.
-
Answer the question How are fields separated?
-
Select Next.
-
Preview your data and select Upload.
CSV file formatting
A CSV file contains a delimiter that marks the separation between fields in the data. The delimiter is usually a comma, but it can be any character. The file also contains fields optionally enclosed with double quotes. Use these guidelines when creating the CSV file:
-
As a best practice, use a
|(pipe) or tab as the delimiter, because those characters are less likely to occur within the data values. -
When a field contains the delimiter, the field must be enclosed in double quotes.
ThoughtSpot supports a wide range of date and timestamp formats in the CSV file. See Date and time formats reference. Blank values in user-uploaded CSV files are interpreted as NULL values. These include the values (case-insensitive):
-
NULL -
\N -
NA -
N/A -
[space]
If you are appending data to an existing schema or table, columns in the CSV file must be in the same order as defined in the target table.
