Kusto Query Language example with demonstration

lOMoARcPSD|16650859




Kql example


Database management systems (Vellore Institute of Technology)




StuDocu is not sponsored or endorsed by any college or university
Downloaded by Jit Dutta ()

, lOMoARcPSD|16650859




Kusto Query Example
Kusto Queries Usage with Example

kusto query language is used for gaining insights on huge volume of data and identify patterns, statistical
analysis model development and many more.

kusto query language (kql) will be demonstrated with examples and commands for getting some overview
of the language.

Row Counting

Count operator can be used for this purpose.

For demonstration we would be using the Storm Events sample table,

stormEvents

|count

Output:

59066

Schema

Getschema would be used for this purpose

stormEvents

|getschema

Output

StartTime 0 System.DateTime datetime

EndTime 1 System.DateTime datetime

EpisodeId 2 System.Int32 int

EventId 3 System.Int32 int

State 4 System.String string

EventType 5 System.String string

InjuriesDirect 6 System.Int32 int

InjuriesIndirect 7 System.Int32 int




Downloaded by Jit Dutta ()