Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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).

...

All functions without the parameter disableCommit=false will not be auto commit after the function has executed.

...

Info

kustoTableCreate Example


Code Block
table result = kustoTableCreate("Default.AZDLookupDb", "lookupdb", "test  | where isnotnull(BeginLocation) | project EpisodeNarrative, EventNarrative | limit 5000");


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


Code Block
initialize {  
  table myTab = tableCreate("myFolder.myProfile", "select id, user from anum" );  
  tableCreateIndex( myTab, "id" );  
 }


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.

...