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. |
...
The sqlExec function is used when updating and inserting data into tables. It returns an integer value stating how many rows were updated/inserted. SQL errors will cause runtime errors (the workflow aborts).
This function can use for execute create or drop table statement.
Code Block |
---|
int sqlExec ( string dbProfile, string sqlQuery ) |
...
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.
...