getschema operator

Switch services using the Version drop-down list. Learn more about navigation.
Applies to: ✅ Microsoft Fabric ✅ 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