Add data through the UI

Add data to existing tables

If you have permissions to upload data and permissions to a data source, you can add to that source by uploading more data with a CSV file.

Use append to add more data to an existing data source.

You can append data to your existing system tables through the ThoughtSpot application, even if the tables were initially loaded using tsload. The CSV file must have the same structure as the table it is being loaded into, including number and type of columns, in the same order as the target table.

To append data into ThoughtSpot:

  1. Log in to ThoughtSpot from a browser.

  2. Click Data on the top navigation bar.

  3. Click the name of the table you would like to append data to.

  4. Click the Load Data button.

  5. Upload the CSV or Excel file by doing one of these options:

    • Click Browse your files and select the file.

    • Drag and drop the file into the drop area.

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

    The options are Yes or No.

  7. Answer the question Do you want to append to the existing data or overwrite it?, select:

    • Append if you are adding new data, and not changing what is already in the table

    • Overwrite if you are replacing all data in the table with new data

      If you choose Overwrite, you lose all existing content in the table, and replace it with new content.
  8. Answer the question Are the fields separated by? by specifying one of:

    • Comma(,)

    • Semicolon(;)

    • Pipe(|)

    • Space

    • Tab

  9. Click Next.

  10. Click Upload.

  11. Click Link to existing data if you want to link the data you uploaded to the data in another table or worksheet. Or click Ask a question if you want to begin a new search.

Add new tables

Any user who belongs to a group that has the privilege Has administration privileges or Can upload user data can upload their own data from the browser. To load the CSV or Excel file into ThoughtSpot:

  1. Log in to ThoughtSpot from a browser.

  2. Click Data, on the top navigation bar.

  3. Select the Utilities tab in the left navigation bar.

  4. In the Upload CSV tile, select Upload CSV.

  5. In Step 1: Upload your file, complete these selections:

    1. Upload the CSV or Excel file by these methods:

      Browse

      Click Browse your files and select the file.

      Drag and drop

      Move the file from the file manager on your computer into the drop area.

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

      The options are Yes or No.

    3. Answer the question Do you want to append to the existing data or overwrite it? by selecting:

      Append

      When adding new data, and not changing what is already in the table

      Overwrite

      When replacing all data in the table with new data

    4. Answer the question Are the fields separated by? by specifying one of:

      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

      Click Next.

  6. In Step 2: Set column names, review your data.

    When necessary, click the column header names to change them to more descriptive and easier names.

    Click Next.

  7. In Step 3: Set column types, review the automatically generated data types for each column, and make necessary changes.

    You can also change column names here.

    These are the possible data types:

    TRUE/FALSE

    Boolean, Yes/no. See details.

    INTEGER

    Smaller integers represented by 32 bits. See details.

    LARGE INTEGER

    Larger integers represented by 64 bits. See details.

    DECIMAL

    Floating point or Decimal. See details.

    TEXT

    Character or text. See details.

    DATE

    Simple date, not including the time component. See details.

    DATE_TIME

    The date and time. See details.

    TIME

    Only the time, not including the date component. See details.

  8. Click Upload.

    When the file uploads, the system reports the results and offers further actions.

    • Click Link to Existing Data if you want to link the data you uploaded to the data in another table or worksheet.

    • Click Search if you want to begin a new search.

    • Click Auto analyze if you want to use the SpotIQ feature to find insights in your new data.