question

gowrishankar-5586 avatar image
0 Votes"
gowrishankar-5586 asked KranthiPakala-MSFT answered

sftp folder permissions in sink

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
image.png (10.7 KiB)
image.png (9.3 KiB)
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.

1 Answer

KranthiPakala-MSFT avatar image
1 Vote"
KranthiPakala-MSFT answered

Hi @gowrishankar-5586 ,

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.


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.