narrow plugin

Applies to: ✅ Azure Data Explorer

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()

Learn more about syntax conventions.

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:

Row Column Value
0 IsHealthy True
0 IsRebalanceRequired False
0 IsScaleOutRequired False
0 MachinesTotal 2
0 MachinesOffline 0
0 NodeLastRestartedOn 2017-03-14 10:59:18.9263023
0 AdminLastElectedOn 2017-03-14 10:58:41.6741934
0 ClusterWarmDataCapacityFactor 0.130552847673333
0 ExtentsTotal 136
0 DiskColdAllocationPercentage 5
0 InstancesTargetBasedOnDataCapacity 2
0 TotalOriginalDataSize 5167628070
0 TotalExtentSize 1779165230
0 IngestionsLoadFactor 0
0 IngestionsInProgress 0
0 IngestionsSuccessRate 100
0 MergesInProgress 0
0 BuildVersion 1.0.6281.19882
0 BuildTime 2017-03-13 11:02:44.0000000
0 ClusterDataCapacityFactor 0.130552847673333
0 IsDataWarmingRequired False
0 RebalanceLastRunOn 2017-03-21 09:14:53.8523455
0 DataWarmingLastRunOn 2017-03-21 09:19:54.1438800
0 MergesSuccessRate 100
0 NotHealthyReason [null]
0 IsAttentionRequired False
0 AttentionRequiredReason [null]
0 ProductVersion KustoRelease_2017.03.13.2
0 FailedIngestOperations 0
0 FailedMergeOperations 0
0 MaxExtentsInSingleTable 64
0 TableWithMaxExtents KustoMonitoringPersistentDatabase.KustoMonitoringTable
0 WarmExtentSize 1779165230