Skip to main content

 

ThoughtSpot

Change the Data Type of a Column

Overview

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

Feature

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:

  1. Connect to the Database with the ThoughtSpot SQL Command Line (TQL).
  2. 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;
  • Was this article helpful?