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.

Related content

For more troubleshooting help, try these resources:

• Connector troubleshooting guide
• Data Factory blog
• Data Factory feature requests
• Azure videos
• Microsoft Q&A page
• Stack Overflow forum for Data Factory
• Twitter information about Data Factory