Troubleshoot the Azure Data Explorer connector in Azure Data Factory and Azure Synapse

APPLIES TO: Azure Data Factory Azure Synapse Analytics

Tip

Try out Data Factory in Microsoft Fabric, an all-in-one analytics solution for enterprises. Microsoft Fabric covers everything from data movement to data science, real-time analytics, business intelligence, and reporting. Learn how to start a new trial for free!

This article provides suggestions to troubleshoot common problems with the Azure Data Explorer connector in Azure Data Factory and Azure Synapse.

Error code: KustoMappingReferenceHasWrongKind

  • Message: Mapping reference should be of kind 'Csv'. Mapping reference: '%reference;'. Kind '%kind;'.

  • Cause: The ingestion mapping reference is not CSV type.

  • Recommendation: Create a CSV ingestion mapping reference.

Error code: KustoWriteFailed

  • Message: Write to Kusto failed with following error: '%message;'.

  • Cause: Wrong configuration or transient errors when the sink reads data from the source.

  • Recommendation: For transient failures, set retries for the activity. For permanent failures, check your configuration and contact support.

For more troubleshooting help, try these resources: