Scalar data types
Applies to: ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel
Every data value, like the value of an expression or a function parameter, has a data type. A data type is either a scalar data type, which is one of the built-in predefined types listed below, or a user-defined record, which is an ordered sequence of name and scalar-data-type pairs, like the data type of a row in a table.
Note
User-defined data types are not supported in Kusto.
Supported data types
The following data types are supported:
| Type | Description |
|---|---|
bool (boolean) |
true (1) or false (0). |
datetime (date) |
An instant in time, typically expressed as a date and time of day. |
| decimal | A 128-bit wide, decimal number. |
| dynamic | An array, a property bag, or a value of any of the other scalar data types. |
guid (uuid, uniqueid) |
A 128-bit globally unique value. |
| int | A signed, 32-bit wide, integer. |
| long | A signed, 64-bit wide, integer. |
real (double) |
A 64-bit wide, double-precision, floating-point number. |
| string | A sequence of zero or more Unicode characters. |
timespan (time) |
A time interval. |
Tip
To check the data type of a value, use the the gettype() function.
Null values
All nonstring data types can be null. When a value is null, it indicates an absence or mismatch of data. For example, if you try to input the string abc into an integer column, it results in the null value. To check if an expression is null, use the isnull() function.
For more information, see Null values.