Estimated reading time: 1 minute

After loading data, you will create the semantic data model that makes the data easy to search. You can make these settings either through the Web interface or by using the model file.

About data modeling

Data modeling is a very lightweight process compared to what you may have experienced in other tools. It enables you to change some of the settings (or properties) of the data so that it becomes more searchable.

You can change these settings in two ways, both of which have the same effect:

  1. Model a data table.
  2. Edit the system-wide data model

Choose the model file method if you want to make many changes in one bulk operation.

Modeling the data allows you to give the columns more search friendly names or predefine how they can be explored and aggregated. When you load data, most of this data modeling metadata is set up for you automatically. However, since you know your data best, you can adjust the modeling settings to improve the experience for your users.

  • Change a table’s data model
    To make modeling settings for a table you’ve just loaded, or to make a quick change to existing settings, use the ThoughtSpot web interface. You can adjust the Columns settings from the data management listing.
  • Edit the system-wide data model
    Properties of your data such as Column Names, Column Visibility, Column and Data Definition, Column Rank, etc. are defined in the modeling file. Use the model file when you want to edit these settings in bulk.
  • Data modeling settings
    Whether you are changing data modeling settings using the modeling file or the Web interface, the settings and their accepted values are the same.