Estimated reading time: 2 minutes

You can change these settings in two ways, both of which change the model. If you want to make a few small changes, you should make them in the ThoughtSpot application . If you want to make many changes you should edit the modeling file. Whether you are changing data modeling settings using the modeling file or the Web interface, the settings and their accepted values are the same.

Modeling settings

This index lists the editable data modeling settings.

Setting name Description
Column Name Sets the name of the column to be used in searches.
Description Adds a text description of what the column contains.
Data Type Read only. Shows the column’s data type.
Column Type Sets the type of column, either ATTRIBUTE or MEASURE.
Additive Controls the type of aggregations that will be available for a column.
Aggregation Sets the default aggregation type for a column.
Hidden Sets the visibility of a column.
Synonyms Adds synonyms that can be used in the search bar to refer to a column.
SpotIQ Preference Excludes specified columns from SpotIQ analyses. By Default, all columns are included in SpotIQ.
Index Type Sets the type of index that will be created for a column.
Geo Config Enables a column to be used in GeoMap visualizations.
Index Priority Changes the priority of a column in search suggestions.
Format Pattern Specifies the format to use for numeric values or dates that show in the column.
Currency Format Specifies the format to use when showing the currencies in a column.
Attribution Dimension Only applies to tables that join over a Chasm Trap. Designates whether the tables depend on this column for attribution.
Entity Category Specifies how to categorize the data in the column by entity type. By default, ENTITY TYPE is not set. Entity categories support SearchIQ so that when you type a natural question, ThoughtSpot better knows how to interpret it. For example, if you ask “who are the top performers?” ThoughtSpot will first choose columns set with PERSON from which to return answers. If you ask “when was the movie Jurassic Park released?”, columns set to TIME will be used to answer the “when” part of the question, and so forth.

Data modeling for worksheets

For worksheets, only some of the settings can be modified, whether you are using the modeling file or the Web interface. The editable settings for worksheets are:

  • Name
  • Description
  • Synonyms

If you want to change any of the settings that cannot be modified in a worksheet, you need to make your changes to the underlying table instead, and they will be reflected in all worksheets that use the table.