Skip to main content
What the max size of number of character that can be extracted in table.column of type Text in celonis.

Celonis backend is vertica, reference for char / varchar https://www.vertica.com/docs/12.0.x/HTML/Content/Authoring/SQLReferenceManual/DataTypes/CharacterDataTypes.htm?tocpath=SQL%20Reference%7CData%20Types%7C_____3.

 

The max is 65k bytes.


Thanks Teuku! for the response. I checked the documentation but could not find the required information.

Actually I have a use case where on CRM application the end user can enter free text of any length. When we extracted this table.column, we saw that not all the text were extracted in to celonis. Some the data from this column were getting truncated. While extracting this table column we change the data type to "TEXT" from String which was by default. So In this context wanted to understand when we extract certain table.column with Text data type then what will the max number of character that can be extracted. Thanks again!


Reply