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).
...
| Note | ||
|---|---|---|
| ||
For MS SQL, the column type timestamp is not supported in tables accessed by by |
...
| Parameter | Description | ||
|---|---|---|---|
| Name of the database where the table resides | ||
| SQL query to send to the database. Note that SQL statements must not end with ';'. Only columns of type number, date and string are supported. | ||
| An optional parameter to disable the commit statement from being performed at the end of every SQL transaction for this particular function. Setting this parameter to false will result in the commit statement to be performed at the end of every SQL transaction for this particular function. By default,
| ||
Returns | A table |
...
The format of this function is the following:
|
Parameter | Description |
|---|---|
| profileName | The name of the profile used. This should be an Azure Profile of the type Azure Data Explorer |
| databaseName | The name of the database in Azure. The cluster name is specified in the Azure profile |
| query | The query to apply to the database in question. This is written in the Kusto Query Language, see example below. |
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 |
tableCreateIndex
Creates an index for one or several columns of a table. This will greatly increase the efficiency of subsequent tableLookup calls on these columns using the equality operator. If the column already has an index, this function has no effect.
...