Reference - Column Data Types

When creating Tables and Columns, each Column has a type property specifying the data type of the Column using an int code.

Specifying a type is only required when creating Columns in a regular Table. For custom Tables, Columns are created automatically with the most appropriate type based on the SQL expression specified for the custom Table.

Versions L2021.9 or newer

The datatypes below apply to Datamodels in Sisense for Linux versions L2021.9 and higher.

Code	Type
0	BigInt
2	Boolean
3	Char
4	Timestamp
5	Decimal
6	Float
8	Integer
13	Real
16	SmallInt
18	VarChar
20	TinyInt
31	Date
32	Time
40	Double
41	Numeric
43	TimestampWithTimezone
44	TimeWithTimezone

Changes compared to previous versions:

• DateTime (4) replaces Timestamp (19)
  This change is backwards compatible - Sisense will still accept the type 19 via the API.

Older linux versions

The datatypes below apply to Datamodels in older versions of Sisense for Linux.

Code	Type
8	Int
0	BigInt
5	Decimal
13	Real
6	Float
19	Timestamp
18	Text

Note that Sisense Datamodels do not have a specific representation for types such as bit or boolean - these are converted to the most appropriate supported data type, most commonly Text.