Edit the system-wide data model

When you load data, ThoughtSpot uses defaults for data modeling metadata. You change these defaults using the data modeling file. Editing this file allows you to view and edit all the system data columns. When you (or your users) add new data to your system, this file changes as it expands to accommodate new data columns.

If you just want to change a subset of your data, use the Change a table’s data model instead.

Overview of the modeling process

The data formats you use in your system are controlled by the modeling file, an Excel file. To make these changes you download the model file, change the model, and upload your changes back into the system.

In each row of the modeling file, all the data properties corresponding to a column from your data are listed. You can modify many of these properties by typing in the new value. Remember these important guidelines when editing the model file:

  • Do not modify any value in a column which contains DoNotModify in the field under the column heading.

  • Make sure to keep the file in the same format as it had when you downloaded it.

The model file contains a row for each column in your data set. It isn’t unusual to have tens of thousand of rows in this file. You can change all or a subset of rows. You can edit the file to leave the heading rows and only those rows you want to change. This can make the file more convenient to work with.

The model file downloads in TSV (tab-separated values) format. After editing, you must save it in TSV format, and it must be UTF-8 encoded. If your model file includes multi-byte characters, edit the file using vi or vim to ensure the file is saved in the correct format. Otherwise, you will not be able to upload it after making your edits.

Download the model file

Before you can make changes to the model file, you need to download it. Then, you edit it using Microsoft Excel, vi/vim, or a similar text editing tool.

To obtain the model file:

  1. Log in to ThoughtSpot from a browser as an Administrator user.

  2. Navigate to Data  Settings  Business Data Model.

  3. Click Download.

    Download the model file
  4. Ensure the file extension is .tsv. This ensures that your editor (vi/vim, and so on) knows the file format is tab-separated values. If you are using Excel, change the file extension to .txt. This ensures that Excel knows the file format is tab-separated values.

    The model file downloads and uploads only in the TSV (tab-separated values) format. Do not change the existing TSV format.

Edit the file and change the settings

You can make changes to the settings using this procedure. To see a list of the changes you can make, see Data modeling settings. You can edit any of the values in the model file, except for those where the words DoNotModify appear under the column header. To make changes in the model file:

  1. Open the model file you downloaded in Excel, vi/vim, or a text editor.

    If you are using Excel, you may see a warning message, saying that the file is in a different format than the one specified by the file extension.

    Click YES to proceed.

  2. Find the column you want to modify.

    Descriptions of the meanings of the columns are listed in Data modeling settings.

  3. Select the value you want to change.

  4. Type in the new value.

  5. After making all your changes, save the model file.

    For ThoughtSpot to allow the file to upload, the model file format must be TSV (tab-separated values), and it must be UTF-8 encoded. If you are using Excel, you must change the extension to .txt. For other editors, keep the .tsv extension. Otherwise, you will not be able to upload it after making your edits.

Upload the edited file

After you have made changes to the modeling file, you must upload it back to ThoughtSpot before the changes will take effect. To upload the model file:

  1. Log in to ThoughtSpot from a browser as an Administrator user.

  2. Navigate to Data  Settings  Business Data Model.

  3. Click Browse your files to upload the model file in .tsv format, or drag and drop it in the zone.

    Upload the model file

    If you receive an error message upon uploading the file, check that the file is in TSV format, and that it does not include any multi-byte characters (for example, Japanese or other multi-byte language characters). If it does, you must download the file again and make your edits using vi or vim.

    You can remove all the rows you have not changed from the model file before uploading it. If you upload a model file that includes only the changed rows, you won’t lose any of the pre-existing model file settings. This is a good option if your model file is causing an error on upload, but you aren’t sure where in the model file the problem is.

As soon as the file is uploaded, ThoughtSpot performs any necessary re-indexing for you automatically. Your new settings will be reflected within a few minutes.