.show data operations

Learn how to use the .show data operations command to return data operations that reached a final state.

Returns a table with data operations that reached a final state. Data operations are available for 30 days from when they ran.

Any operation that results in new extents (data shards) added to the system is considered a data operation.

Permissions

You must have Database Admin or Database Monitor permissions to see any data operations invoked on your database.

Any user can see their own data operations.

For more information, see Kusto role-based access control.

Syntax

.show data operations

Returns

This command returns a table with the following columns:

Output parameterTypeDescription
TimestampdatetimeThe time when the operation reached its final state.
DatabasestringThe database name.
TablestringThe table name.
ClientActivityIdstringThe operation client activity ID.
OperationKindstringOne of BatchIngest, SetOrAppend, RowStoreSeal, MaterializedView, QueryAcceleration, and UpdatePolicy.
OriginalSizelongThe original size of the ingested data.
ExtentSizelongThe extent size.
RowCountlongThe number of rows in the extent.
ExtentCountintThe number of extents.
TotalCputimespanThe total CPU time used by the data operation.
DurationtimespanThe duration of the operation.
PrincipalstringThe identity that initiated the data operation.
PropertiesdynamicAdditional information about the data operation.

Example

The following example returns information about UpdatePolicy, BatchIngest, and SetOrAppend operations.

.show data operations

Output

TimestampDatabaseTableClientActivityIdOperationKindOriginalSizeExtentSizeRowCountExtentCountTotalCpuDurationPrincipalProperties
2024-07-18 15:21:10.5432134TestLogsUTResultsDM.IngestionExecutor;abcd1234-1234-1234-abcd-1234abcdce;1UpdatePolicy100,82975,578279100:00:00.265625000:00:28.9101535aadapp=xxx{“SourceTable”: “UTLogs”}
2024-07-18 15:21:12.9481819TestLogsUTLogsDM.IngestionExecutor;abcd1234-1234-1234-abcd-1234abcdce;1BatchIngest1,045,027,298123,067,9471,688,705200:00:22.984375000:00:29.9745733aadapp=xxx{“Format”: “Csv”,“NumberOfInputStreams”:2}
2024-07-18 15:21:16.1095441KustoAutoIncidentKustoGPTSummarycdef12345-6789-ghij-0123-klmn45678SetOrAppend1,4203,1901100:00:00.015625000:00:00.0638211aaduser=xxx