Data value casing

You can now define the case of columns in a Model, by changing the case of the columns at table level. By default, ThoughtSpot uses the LOWER function for string comparisons. In cases where this function impacts performance, you may want to use the data value casing feature to change the column’s case.

This feature is not the same as case-sensitive search.

Data value case behavior

The existing behavior defines the column’s case as DEFAULT (where ThoughtSpot uses the LOWER function). If defined as MIXED, then the LOWER function will be included by default.

You can also define a column as ALL_LOWERCASE, where the SQL serialization will not include the LOWER function during string comparison. If defined as ALL_UPPERCASE, then the LOWER function will not be included.

Note that ThoughtSpot does not sample the data for these columns.

For more information, see Data value casing.