narrow plugin

Learn how to use the narrow plugin to display a wide table.

The narrow plugin “unpivots” a wide table into a table with three columns:

  • Row number
  • Column type
  • Column value (as string)

The narrow plugin is designed mainly for display purposes, as it allows wide tables to be displayed comfortably without the need of horizontal scrolling.

The plugin is invoked with the evaluate operator.

Syntax

T | evaluate narrow()

Examples

The following example shows an easy way to read the output of the Kusto .show diagnostics management command.

.show diagnostics
 | evaluate narrow()

The results of .show diagnostics itself is a table with a single row and 33 columns. By using the narrow plugin we “rotate” the output to something like this:

RowColumnValue
0IsHealthyTrue
0IsRebalanceRequiredFalse
0IsScaleOutRequiredFalse
0MachinesTotal2
0MachinesOffline0
0NodeLastRestartedOn2017-03-14 10:59:18.9263023
0AdminLastElectedOn2017-03-14 10:58:41.6741934
0ClusterWarmDataCapacityFactor0.130552847673333
0ExtentsTotal136
0DiskColdAllocationPercentage5
0InstancesTargetBasedOnDataCapacity2
0TotalOriginalDataSize5167628070
0TotalExtentSize1779165230
0IngestionsLoadFactor0
0IngestionsInProgress0
0IngestionsSuccessRate100
0MergesInProgress0
0BuildVersion1.0.6281.19882
0BuildTime2017-03-13 11:02:44.0000000
0ClusterDataCapacityFactor0.130552847673333
0IsDataWarmingRequiredFalse
0RebalanceLastRunOn2017-03-21 09:14:53.8523455
0DataWarmingLastRunOn2017-03-21 09:19:54.1438800
0MergesSuccessRate100
0NotHealthyReason[null]
0IsAttentionRequiredFalse
0AttentionRequiredReason[null]
0ProductVersionKustoRelease_2017.03.13.2
0FailedIngestOperations0
0FailedMergeOperations0
0MaxExtentsInSingleTable64
0TableWithMaxExtentsKustoMonitoringPersistentDatabase.KustoMonitoringTable
0WarmExtentSize1779165230