Search code examples
azurekqlazure-log-analytics-workspace

How can we fetch the datasize of a kusto query in Log Analytics Workspace?

I want to fetch the data size of a specific kusto query.

Query:

CustomData_CL
| where TimeGenerated  between (datetime(2022-09-14 04:00:00) .. datetime(2022-09-14 05:00:00))

Can anyone please suggest on the same ?

Solution

  • estimate_data_size()

    CustomData_CL
| where TimeGenerated  between (datetime(2022-09-14 04:00:00) .. datetime(2022-09-14 05:00:00))
| summarize sum(estimate_data_size(*))