Encrypt the CSV file before transferring to SFTP

Divakar Krishnan 106 Reputation points

Dear Team,

As per our requirement, we need to encrypt the CSV file and transfer it to SFTP using ADF.

I have checked in ADF, but there is no option to encrypt the CSV file.

Can someone please assist on how to encrypt the CSV file using public shared key using ADF?


Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,142 questions
0 comments No comments
{count} votes

Accepted answer
  1. Nandan Hegde 31,346 Reputation points MVP

    Based on my understanding

    Unfortunately there is no out of box feature in Azure Data factory to perform encryption/decryption of files. Below are couple of feature request suggestions submitted by other Azure users. I would recommend you to please comment and/or up-vote the below user voice items to increase the priority of feature implementation.



    In order to transform/process data in a way that isn't supported by Data Factory, you can create a Custom logic with your own data movement or transformation logic and use the Custom activity in a pipeline. Or another option you could try out is Azure Function Activity.

    Additional info :
    Here are few related helpful resources:

2 additional answers

Sort by: Most helpful
  1. Vandana Chaturvedi 1 Reputation point

    I was told that since we are sending it over SFTP, we don't need to encrypt the data. As per my understanding even if we are sending data over SFTP, we should encrypt it.

    0 comments No comments

  2. Divakar Krishnan 106 Reputation points

    @Vandana Chaturvedi , We should encrypt the file even if we are sending data over SFTP.


    0 comments No comments