Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: ✅ Azure Data Explorer
Shows the queued ingestion operations. Ingestion operations are tracked after the .ingest-from-storage-queued command starts.
Note
Queued ingestion commands run on the data ingestion URI endpoint https://ingest-<YourClusterName><Region>.kusto.chinacloudapi.cn.
Permissions
You need Table Ingestor permissions on the table associated with the IngestionOperationId or IDs.
Syntax
.show queued ingestion operations "IngestionOperationId"
.show queued ingestion operations ("IngestionOperationId" [, ... ])`
.show queued ingestion operations "IngestionOperationId" details
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| IngestionOperationId | string |
The operation ID for which to show details. |
Returns
Returns for queued ingestion operations with details
The command returns a table with details about the ingestion status for each blob ingested in the operation.
| Output parameter | Type | Description |
|---|---|---|
| IngestionOperationId | string |
The unique operation identifier. |
| BlobURL | string |
The URL of the blob file, when the ingestion operation includes blob files. |
| IngestionStatus | string |
The status of the ingestion. |
| StartedAt | datetime |
Date/time, in UTC, at which the .ingest-from-storage-queued was executed. |
| CompletedAt | datetime |
Date/time, in UTC, at which the .ingest-from-storage-queued was completed. |
| FailedReasons | string |
Reasons for the ingestion failure. |
Returns for queued ingestion operations
The command returns a table with the latest update information for each ID.
| Output parameter | Type | Description |
|---|---|---|
| IngestionOperationId | string |
The unique operation identifier. |
| StartedOn | datetime |
Date/time, in UTC, at which the .ingest-from-storage-queued was executed. |
| LastUpdatedOn | datetime |
Date/time, in UTC, when the status was updated. |
| State | string |
The state of the operation. |
| Discovered | long |
Count of the blobs that were listed from storage and queued for ingestion. |
| Pending | long |
Count of the blobs to be ingested. |
| Canceled | long |
Count of the blobs that were canceled due to a call to the .cancel queued ingestion operation command. |
| Ingested | long |
Count of the blobs that have been ingested. |
| Failed | long |
Count of the blobs that failed permanently. |
| SampleFailedReasons | string |
A sample of reasons for blob ingestion failures. |
| Database | string |
The database where the ingestion process is occurring. |
| Table | string |
The table where the ingestion process is occurring. |
States
The following table describes the possible values for the result table's State column.
| Value | Description |
|---|---|
| InProgress | The operation is still running. |
| Completed | The operation completed successfully. |
| Failed | The operation didn't complete successfully. |
| Canceled | The user canceled the operation. |
Examples
The examples in this section show how to use the syntax to help you get started.
Single operation ID
The following example shows the queued ingestion operations for a specific operation ID.
.show queued ingestion operations "00001111;11112222;00001111-aaaa-2222-bbbb-3333cccc4444"
Output
| IngestionOperationId | Started On | Last Updated On | State | Discovered | InProgress | Ingested | Failed | Canceled | SampleFailedReasons | Database | Table |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 00001111;11112222;00001111-aaaa-2222-bbbb-3333cccc4444 | 2025-01-10 14:57:41.0000000 | 2025-01-10 14:57:41.0000000 | InProgress | 10387 | 9391 | 995 | 1 | 0 | Stream with ID '*****.csv' has a malformed CSV format* | MyDatabase | MyTable |
Multiple operation IDs
The following example shows the queued ingestion operations for multiple operation ID numbers.
.show queued ingestion operations ("00001111;11112222;00001111-aaaa-2222-bbbb-3333cccc4444", "11112222;22223333;11110000-bbbb-2222-cccc-3333dddd4444")
Output
| IngestionOperationId | Started On | Last Updated On | State | Discovered | InProgress | Ingested | Failed | Canceled | SampleFailedReasons | Database | Table |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 00001111;11112222;00001111-aaaa-2222-bbbb-3333cccc4444 | 2025-01-10 14:57:41.0000000 | 2025-01-10 15:15:04.0000000 | InProgress | 10387 | 9391 | 995 | 1 | 0 | Stream with ID '*****.csv' has a malformed CSV format* | MyDatabase | MyTable |
| 11112222;22223333;11110000-bbbb-2222-cccc-3333dddd4444 | 2025-01-10 15:12:23.0000000 | 2025-01-10 15:15:16.0000000 | InProgress | 25635 | 25489 | 145 | 1 | 0 | Unknown error occurred: Exception type 'System.Exception' was thrown | MyDatabase | MyOtherTable |
Show details
The following example shows details for each blob in the queued ingestion operation.
.show queued ingestion operations '00001111;11112222;00001111-aaaa-2222-bbbb-3333cccc4444' details
Output
| IngestionOperationId | BlobUrl | IngestionStatus | StartedAt | CompletedAt | FailedReason |
|---|---|---|---|---|---|
| 00001111;11112222;00001111-aaaa-2222-bbbb-3333cccc4444 | https://<blobstoragelocation>/100.csv.gz | Pending | 2025-02-09T14:56:08.8708746Z | ||
| 00001111;11112222;00001111-aaaa-2222-bbbb-3333cccc4444 | https://<blobstoragelocation>/102.csv.gz | Succeeded | 2025-02-09T14:56:09.0800631Z | 2024-02-09T15:02:06.5529901Z | |
| 00001111;11112222;00001111-aaaa-2222-bbbb-3333cccc4444 | https://<blobstoragelocation>/103.csv.gz | Failed | 2025-02-09T14:56:09.3026602Z | Failed to download |