This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 84%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKA%3C/text%3E%3C/svg%3E)
Could you please assist here to resolve this issue below ?
We are trying to read Delta table and export it as CSV using Data Flow. Reading Delta table via inline dataset from ADLS Gen2 and export as CSV (csv dataset) into Azure Blob Storage.
Getting below error while exporting as CSV at sink.
ERROR :
Error code : DFExecutorUserError
Failure type User: configuration issue
Details : Job failed due to reason: at Sink 'SinkSource': Spark job failed in one of the cluster nodes while writing data in one of the partitions to sink, with following error message: This request is not authorized to perform this operation using this permission.
Note : Dataflow fails, but CSV has been exported into temporary folders - https://<storage-account>.blob.core.windows.net/containername/foldername/_temporary/0/_temporary/ with different name like part0000werwe.csv inside _temporary location.
But we are excepting to export as csv inside foldername location , even though slink setting is File name option - output to single file ,file name - xyz.csv and Optimize Partition option : single.
Linked service (created using SAS) for Slink - Container level RWL privilege (Azure Blob Storage)
Could you please help us to resolve this issue.
@Vinodh247 , Yes slink side container and folder exist , but we are trying to write as CSV , not spark partition
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 38%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EQ%3C/text%3E%3C/svg%3E)
@Kashif Ahmed Could you please let us know what are the permissions granted to the SAS token? I hope it is valid and not expired.
If any corporate policies are blocking the permissions, then please try with other ADF accounts in different tenant to remove the permission issue from the equation!
@SatishBoddu-MSFT, ADF issue has been resolved, it was SAS token issue. SAS token should have read/write/delete/list access
Kashif Ahmed: Can you check if the user has proper permissions on the storage account where he is trying to access the files from?
Storage Blob Data Contributor = Use to grant read/write/delete permissions to Blob storage resources.
@Vinodh247 : Yes we have access to read data from source side (we can preview the data), issue occurs while writing to Slink Azure Blob Storage. Linked service for slink based on the SAS token , token with container level read/write/list privilege.
The error states that there is permission issue when it tries to write into the spark partitions. Can you make sure the container path & folder name mentioned in the dataset exist?