0

We are using Azure Data factory to move data from Source like Azure SQL and Azure Postgres to destination as Azure data lake.There is some sensitive data which needs to be masked. Is it possible to have data masking in Azure Data factory during transformation phase only?

Thanks! in advance

Abhishek K
  • 3,047
  • 1
  • 6
  • 19
Himanshu Garg
  • 1
  • 1

2 Answers2

0

You can leverage on Cryptographic functions of the source DB and use it in the SELECT statement to get encrypted data into the data lake. If you use a reversible function you can decrypt later on. You can also mask the data using SQL function (e.g selecting only a substring of a sensitive column) but then it won't be reversible (same thing if you leverage Data Masking on the Azure SQL DB)

Here the Cryptographic functions for Azure SQL DB

zinco
  • 39
  • 3
0

Hi there is a option of dynamic data masking in the portal where you have deployed the database. You can go there and select the table and column to mask your data

https://learn.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-overview?view=azuresql

Debashish
  • 3
  • 5
  • As it’s currently written, your answer is unclear. Please [edit] to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Oct 22 '22 at 01:00