question

MatamSavitha-7051 avatar image
0 Votes"
MatamSavitha-7051 asked PRADEEPCHEEKATLA-MSFT commented

could not ingest data from Azure SQL to ADX through ADF

Hi
i am unable to ingest data from Azure Sql to Azure Data Explorer through Azure Data Factory. the following error i am getting

ErrorCode=UserErrorKustoWriteFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Failure status of the first blob that failed: Insufficient security permissions to execute request,Source=Microsoft.DataTransfer.Runtime.KustoConnector,

azure-sql-databaseazure-data-explorer
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @MatamSavitha-7051,

Following up to see if the below suggestion was helpful. And, if you have any further query do let us know.


  • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you.

0 Votes 0 ·

1 Answer

AlbertoMorillo avatar image
0 Votes"
AlbertoMorillo answered AlbertoMorillo edited

Please try to go into ADX user permissions and add ADF as a "user"(app) with write permissions.

This integration article needs to be considered also.

Hope this helps.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.