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.
Switch services using the Version drop-down list. Learn more about navigation.
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 |