gettype()
Applies to: ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel
Returns the runtime type of its single argument.
The runtime type may be different than the nominal (static) type for expressions whose nominal type is dynamic
; in such cases gettype()
can be useful to reveal the type of the actual value (how the value is encoded in memory).
Syntax
gettype(
value)
Learn more about syntax conventions.
Parameters
Name | Type | Required | Description |
---|---|---|---|
value | scalar | ✔️ | The value for which to find the type. |
Returns
A string representing the runtime type of value.
Examples
Expression | Returns |
---|---|
gettype("a") |
string |
gettype(111) |
long |
gettype(1==1) |
bool |
gettype(now()) |
datetime |
gettype(1s) |
timespan |
gettype(parse_json('1')) |
int |
gettype(parse_json(' "abc" ')) |
string |
gettype(parse_json(' {"abc":1} ')) |
dictionary |
gettype(parse_json(' [1, 2, 3] ')) |
array |
gettype(123.45) |
real |
gettype(guid(12e8b78d-55b4-46ae-b068-26d7a0080254)) |
guid |
gettype(parse_json('')) |
null |