79657760

Date: 2025-06-08 10:53:32
Score: 0.5
Natty:
Report link

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:

  1. Run a representative query on the table:

This approach helps the engine see the data and triggers stats recomputation internally.

MyTable
| summarize count(), dcount(ColumnName), countif(isnull(ColumnName))
  1. Use the .analyze command (if available in your cluster, you can request stats update):
.analyze table MyTable with (UpdateStatistics=true)
  1. If you need immediate statistics:
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

Reasons:
  • Blacklisted phrase (0.5): Thank you
  • Long answer (-1):
  • Has code block (-0.5):
  • User mentioned (1): @Yoni
  • Low reputation (0.5):
Posted by: Mihir Saxena