Kusto Query Language (KQL) - Count Operator

Basic Syntax:

The basic syntax for the count operator is as follows:

TableName
| count
    

• TableName: Specifies the name of the table for which you want to count the rows.

Common Use Cases:

1. Counting Rows:

The primary purpose of the count operator is to determine the number of rows in a table. It provides a count of the total records in the specified table.

MyTable
| count
    

2. Grouped Count:

You can use the count operator in conjunction with other operators like summarize to perform grouped counts. This allows you to count rows based on specific criteria or groupings.

MyTable
| summarize CountPerCategory = count() by Category
    

3. Conditional Count:

By combining the count operator with the where operator, you can count rows that meet certain conditions or criteria.

MyTable
| where Column1 > 50
| count
    

4. Count Distinct Values:

If you want to count distinct values within a column, you can use the distinct operator along with count for unique counts.

MyTable
| distinct Column1
| count
    

The count operator is a fundamental tool for calculating row counts and is often used in various data analysis scenarios in Kusto Query Language.