getschema operator

Applies to: ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel

Produce a table that represents a tabular schema of the input.

Syntax

T | getschema

Learn more about syntax conventions.

Examples

The following example creates a tabular schema of the input.

Run the query

StormEvents
| getschema

Output

ColumnName ColumnOrdinal DataType ColumnType
StartTime 0 System.DateTime datetime
EndTime 1 System.DateTime datetime
EpisodeId 2 System.Int32 int
EventId 3 System.Int32 int
State 4 System.String string
EventType 5 System.String string
InjuriesDirect 6 System.Int32 int
InjuriesIndirect 7 System.Int32 int
DeathsDirect 8 System.Int32 int
DeathsIndirect 9 System.Int32 int
DamageProperty 10 System.Int32 int
DamageCrops 11 System.Int32 int
Source 12 System.String string
BeginLocation 13 System.String string
EndLocation 14 System.String string
BeginLat 15 System.Double real
BeginLon 16 System.Double real
EndLat 17 System.Double real
EndLon 18 System.Double real
EpisodeNarrative 19 System.String string
EventNarrative 20 System.String string
StormSummary 21 System.Object dynamic