Explains what the feature is or what its benefits are to the user or customer.
When you issue the TQL command to convert a column from one data type to another, the conversion is handled automatically. You do not need to do anything to ensure that the worksheets, answers, and pinboards created on top of the table will still work.
To change the data type of a column:
- Connect to the Database with the ThoughtSpot SQL Command Line (TQL).
- Issue the command to change the data type using this syntax:
TQL> ALTER TABLE <table> MODIFY COLUMN <column> <new_data_type>;For example:
ALTER TABLE fact100 MODIFY COLUMN product_id int;