narrow plugin

The narrow plugin "unpivots" a wide table into a table with just three columns: Row number, column type, and 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 control 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