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?
-
Changing the data type via the model.csv file is not permitted.
You will note at the top of the file that under the column name "DataType" it states "DoNotModify".
If you do change it and ty and upload the model file I suspect it would fail.
Reply -
Paul Froggatt thanks for the reply Paul. I saw that warning, but what's the difference between initiating a tql statement to modify it vs the csv file?
Reply -
I have successfully done this via TQL, but never tried via the model.csv file
do you not have access to TQL?Reply -
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 -
Marc Price Hey Marc, I do. Was just seeing whether this was possible since it seemed to be consolidated within one aspect of the tool. Don't see why we would need terminal access to do this if it could potentially be done through UI. Seeing Paul's response below gives me better understanding.
Reply -
Paul Froggatt Makes sense, Paul. Thanks for the clarification!
Reply
