Changing Data Type through Data Model
Hi All,
Has anyone tried changing the Data Type of a table through the Data Model file (model.csv) through the ThoughtSpot UI?
I understand you're able to change it via TQL: https://community.thoughtspot.com/t/63bc17/can-i-change-data-type-from-bigint-to-varchar
Are there any repercussions doing through the model csv file?
-
There is a degree of separation, or rather abstraction, between the underlying physical data model in the back-end and the semantic model in the front-end.
On the back-end, TQL operates at the physical level, note you can't use it to change any semantics for a column such as the column type or the aggregation type etc.
Equally on the front-end, the model file operates at the semantic level and you can't use it to change any physical attributes such as the physical column name or the datatype.
So think of them as 2 distinct models with 2 distinct tools to manipulate them.
Reply