A special table type is used to handle database table lookups with optional caching in memory. All of the following column references may be either numeric (column index, starts at 0) or string (column name).
The table lookup only supports int, string and date types.
All functions without the parameter disableCommit=false
will not be auto commit after the function has executed.
Note |
---|
Note!For MS SQL, the column type timestamp is not supported in tables accessed by . Use column type datetime instead. Please refer to the Notes section in the Database Functions page for details on allowed database data type. |
...
Info | ||
---|---|---|
kustoTableCreate Example
|
The Kusto data types will be interpreted as the following types in the resulting table object:
Azure Type | APL Type |
---|---|
bool | boolean |
datetime | date |
dynamic | string |
int | int |
long | long |
real | bigdec |
string | string |
decimal | bigdec |
timespan | string |
...
Info | ||
---|---|---|
Example - Using tableCreateIndex
|
tableGet
The tableGet function returns the value of a table entry. The value is returned as an any object, which means the returned value is of the same type as the value extracted.
...