.dup-next-failed-ingest command
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer
Use the .dup-next-failed-ingest command for ad-hoc troubleshooting of your data ingestion flows.
.dup-next-failed-ingest will watch the next ingestion for an ingestion failure. If the next ingestion fails, the successfully downloaded ingestion source file(s) and a file containing metadata on the ingestion request will be uploaded to the specified storage container. Since this command only watches one subsequent ingestion, run this command each time you want to watch the next ingestion.
The file uploads to the storage container and the ingestion are performed by the same node. The command takes effect on a single ingest operation and has no persistent state, so if the admin node changes between the command execution and the next ingestion, you'll need to rerun the command. Watch the storage container to know when the duplication is completed.
Note
- This command runs in the context of a specific database.
- Supported storage is Azure blob containers.
Permissions
You must have at least Database Admin permissions to run this command.
Syntax
.dup-next-failed-ingest into TableName to StorageContainerPath
Learn more about syntax conventions.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| TableName | string |
✔️ | The name of the table from which the next ingestion will be duplicated. |
| StorageContainerPath | string |
✔️ | The path to the blob container that will store the duplication. We recommend prefacing the path with "h@" to hide sensitive information. To learn more, see obfuscated string literals. |
Returns
The provided TableName, StorageContainerPath, and IngestionCommandFilePath. The ingestion command file path is the location of the ingestion file request within the blob container.
Upon the next pull data ingestion, the ingestion source file(s) and a file containing metadata will be uploaded to the blob container.
Example
.dup-next-failed-ingest into PerfCounter to h@'https://kustorenginsomelocation.blob.core.windows.net/ingestion-duplication-perf-counter;storagekey...==
.dup-next-failed-ingest into PerfCounter to h@'https://kustorenginsomelocation.blob.core.windows.net/ingestion-duplication-perf-counter?<SAS key that allows write>
| TableName | StorageContainerPath | IngestionCommandFilePath |
|---|---|---|
| PerfCounter | https://kustorenginsomelocation.blob.core.windows.net/ingestion-duplication-perf-counter | ingestionrequest-KustoEH-PerfCounter-083736db-8cf7-4166-85fd-74ef54e491d1 |