count operator
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel
Returns the number of records in the input record set.
Syntax
T | count
Learn more about syntax conventions.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| T | string |
✔️ | The tabular input whose records are to be counted. |
Returns
This function returns a table with a single record and column of type
long. The value of the only cell is the number of records in T.
Example
The examples in this article use publicly available tables in the help cluster, such as the
StormEventstable in the Samples database.
The examples in this article use publicly available tables, such as the
StormEventstable in the Weather analytics sample data.
When you use the count operator with a table name, like StormEvents, it will return the total number of records in that table.
StormEvents | count
Output
| Count |
|---|
| 59066 |
Related content
For information about the count() aggregation function, see count() (aggregation function).