Note

Access to this page requires authorization. You can try signing in or .

Access to this page requires authorization. You can try .

Queries for the FailedIngestion table

For information on using these queries in the Azure portal, see Log Analytics tutorial. For the REST API, see Query.

Failed ingestions by errors

How many ingestion failures accrued (by ErrorCode).

FailedIngestion
| summarize count() by ErrorCode

Failed ingestions timechart

How many ingestion failures accrued (timechart).

FailedIngestion
| summarize count() by bin(TimeGenerated, 5m)
| render timechart

Failed Ingestions

How many ingestion failures accrued (by cluster, database, table, ErrorCode, status).

FailedIngestion
| parse _ResourceId with * "providers/microsoft.kusto/clusters/" cluster_name // Get the cluster name from the ResourceId string
| summarize count() by bin(TimeGenerated, 1h), cluster_name, Database, Table, ErrorCode, FailureStatus

Feedback

Was this page helpful?

Additional resources

  • Last updated on