Explains what the feature is or what its benefits are to the user or customer.
ThoughtSpot supports the common data types. Compare these with the data types you want to load, and do any necessary conversion ahead of loading the data.
Supported data types
The tables you create to receive the data must have the same number of columns and data types as the data you will be loading. Choose a data type for each column from the list of supported data types:
Table 1. Supported data types
Kind of data
Supported data types
Specify the maximum number of characters, as in VARCHAR(255). The size limit is 1GB for VARCHAR values.
DOUBLE is recommended.
Can be true or false.
INT holds 32 bits.
BIGINT holds 64 bits.
Date or time
DATETIME, TIMESTAMP, and TIME are stored at the granularity of seconds.
TIMESTAMP is identical to DATETIME, but is included for syntax compatibility.
Note: There is a 1GB limitation on the number of characters for VARCHAR. If you have any VARCHAR data that exceeds this limit, the entire load will fail.
Geographical data types
For geographical data types, use VARCHAR. For latitude and longitude, you can use either VARCHAR or DOUBLE. After loading the data, designate it as a geographical data type when you Model data in bulk in the modeling file. Wherever abbreviations or codes are used, they are the same as what the USPS (United States Postal Service) recognizes.
These types of data can be designated as geographical data, which enables them to be visualized using the Geo chart types:
Table 2. Data that uses geo charts
name: United States
long name: United States
name_sort: United States of America
admin: United States of America
brk_name: United States
formal_en: United States of America
Counties in the United States
santa clara county
pike county, ohio
pike county, OH
States in the United States
US Postal Service abbreviation: CA
Must be used with LONGITUDE
Must be used with LATITUDE
Zip codes and zip codes +4 in the United States
po_name: MT MEADOWS AREA
Note: You cannot upload your own custom boundaries.