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:

  1. Select Data in the top navigation bar.

  2. Select Utilities in the side navigation bar.

  3. Select Upload CSV.

    Alternatively, navigate to step one of Setup, and click upload CSV.

  4. Upload the CSV or Excel file using one of these options:

    • Click Browse your files and select the file.

    • Drag and drop the file into the drop area.

  5. Answer the question Are the column names already defined in the file header?

  6. Answer the question How are fields separated?

    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

  7. Click Next.

  8. If column names are missing, click 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.

  9. Click Next.

  10. 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.

  11. Click 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:

  1. Select Data in the top navigation bar.

  2. Click on your current CSV file in the list of data sources.

  3. Select Replace CSV in the top right corner of your screen.

  4. Answer the question Are the column names already defined in the file header?

  5. 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.

  6. Answer the question How are fields separated?

  7. Click Next.

  8. Preview your data and click 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.