Mask data when transferring it

Sasha Sasha 80 Reputation points

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 ?

Azure SQL Database
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
656 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
8,489 questions
0 comments No comments
{count} votes

Accepted answer
  1. Amira Bedhiafi 8,711 Reputation points

    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.

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful