Mask data when transferring it

Question

I am using ADF to move data from an Azure SQL to an Azure data lake and since it is sensitive data we want to mask it. Is it possible to mask it or encrypt it in Azure Data factory during the transfer phase ?

Answer 1

You can use cryptographic functions within the SELECT statement to ensure the data is encrypted during this process. If a reversible cryptographic function is employed, you can decrypt the data at a later stage as needed. Alternatively, you could opt for data masking techniques, such as selecting only a portion of a sensitive column using SQL functions. However, it's important to note that this method does not allow for data reversal, similar to the effect of using Data Masking features in Azure SQL Database.

https://learn.microsoft.com/en-us/sql/t-sql/functions/cryptographic-functions-transact-sql?view=sql-server-ver15