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)replacesTimestamp (19)
This change is backwards compatible - Sisense will still accept the type19via 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.