Get the count of each column of Kusto Table

In Kusto Query Language (KQL), you can’t directly get the count of each column in a single command. However, you can get the count of each column one by one using the count() function. Here’s an example:

datatable | summarize count(Column1), count(Column2), count(Column3)

Replace ‘datatable’ with your table name and ‘Column1’, ‘Column2’, ‘Column3’ with your column names.

This will give you the count of non-null values in each of these columns. If you want to include null values in your count, you can use dcount() function instead.

Please note that this will not provide the count of unique values. If you need count of unique values, you can use dcount() function.