Thank you @Yoni L. for sharing your views, I totally agree with you.
The command:
.show table MyTable column statistics
does work, but it's undocumented and may return empty results after table creation or ingestion. This happens because Kusto collects column statistics asynchronously they’re computed lazily and cached, not updated in real time.
Currently, there is no official command to force-refresh column statistics in Kusto, but you can implicitly trigger a statistics refresh using the following approaches:
This approach helps the engine see the data and triggers stats recomputation internally.
MyTable
| summarize count(), dcount(ColumnName), countif(isnull(ColumnName))
.analyze table MyTable with (UpdateStatistics=true)
MyTable
| summarize
TotalRows = count(),
NullCount = countif(isnull(ColumnName)),
DistinctValues = dcount(ColumnName)
This gives accurate, up-to-date statistics at query time.
For reference kindly check - .show table data statistics command