Share via

sftp folder permissions in sink

Gowri Shankar 226 Reputation points
2021-06-09T10:56:58.217+00:00

Hi,

Our pipeline copy the files from source sftp to our ADLS and then it copies the file from ADLS to SAP sftp folder.

In Source SFTP folder the file has rw_rw_ permission for the owner and groups.
103808-image.png

But after copying the file into destination SAP sftp folder,the file has rw_r_ permission for the owner and groups as below.
But we need execute(x) permission also for the file placed in below folder.

103881-image.png

May I know how can I give that permission via in ADF ?. Is that possible?

Thanks

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,646 questions
0 comments
Accepted answer
  1. KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator
    2021-06-09T19:32:40.87+00:00

    Hi @Gowri Shankar ,

    Thanks for reaching out and posting your query.

    I don't think ADF is the suitable for your requirement as it is not intended for that purpose. It is better to have another custom application job that can update the file permission after ADF copy is completed.

    But if you know of a way to update SFTP permissions programmatically, then you may try exploring Azure function activity and Custom Activity in ADF which are intended to transform/process data in a way that isn't supported by Data Factory. The custom activity runs your customized code logic on an Azure Batch pool of virtual machines.

    Hope this info helps.

    ----------

    Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.

    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.