Skip to main content

 

ThoughtSpot

Data Modeling Settings

Overview

Explains what the feature is or what its benefits are to the user or customer.

Feature

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

You can change these settings in two ways, both of which have the same effect:
  1. Model data in the Web interface.
  2. Model data in bulk in the model file.
Choose the model file method if you want to make many changes in one bulk operation.
This index lists the editable data modeling settings:
Table 1. Modeling settings
Setting name Description Can be modeled in a Worksheet
Column Name Sets the name of the column to be used in searches. Yes
Description Adds a text description of what the column contains. Yes
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 MEASURE columns.  
Hidden Sets the visibility of a column.  
Synonyms Adds synonyms that can be used in the search bar to refer to a column. Yes
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.  

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.

  • Was this article helpful?