Estimated reading time: 3 minutes

You can change these settings in two ways, both of which have 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. You can apply these settings to columns in tables or worksheets.

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.
Synonyms Adds synonyms that can be used in the search bar to refer to a column.
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.
Index Type Sets the type of index that will be created for a column.
Geo Type Enables a column to be used in GeoMap visualizations.
Priority Changes the priority of a column in search suggestions.
Number Format Specifies the format to use when showing a numeric value in the column.
Date Format Specifies the format to use when showing the dates in a 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. You cannot change the attribution dimension in the modeling file. You can only configure it on a table-by-table basis.

Data modeling best practices

As a best practice, make any data modeling settings in the table when you will be creating multiple worksheets that use that table. This way, you won’t have to make the same settings in each worksheet. The settings will be inherited when you create worksheets that uses columns from the table.

If you have settings that only apply in the context of a particular worksheet, make those settings in the worksheet rather than in the underlying table(s).

Note that if you make your settings at the table level, and then create a worksheet that uses columns from the table, the settings are inherited from the table at the point in time that the worksheet is created. If you then go back and change the settings at the table level, your changes will not be reflected in the worksheet.

If you want the worksheet to have the changes you made at the table level, you’ll need to drop those columns from the worksheet and re-add them. Then save the worksheet. At this point, the new settings will be used in the worksheet. Note that any saved answers or pinboards based on the worksheet may display differently because of your changes. For example, if you’ve changed the GeoMap setting from “None” to “Country”, you will now see a map where before you might have seen a table.