Azure SQL Database
An Azure relational database service.
5,936 questions
You can use Presidio and Azure Databricks to help you with the anonymization of sensitive data. Please read this document.
Microsoft Fabric: Anonymize data in dataflow pipeline gen2
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(265.6, 72%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGA%3C/text%3E%3C/svg%3E)
Gopal Annasundaram
0
Reputation points
I'd like to load a subset of tables from production Azure SQL to Lakehouse for further processing and analytics. I'd like to anonymize data like email, user's name etc in the dataflow pipeline Gen2 as the data is read from Azure Sql and written to Lakehouse. How do I go about doing it?
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 69%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Sai Raghunadh M 1,760 Reputation points Microsoft Vendor2024-12-16T02:41:14.3766667+00:00 Just checking in to see if the below answer provided by Alberto Morillo helped.
If this answers your query, do click
Accept AnswerandYesfor was this answer helpful. And, if you have any further query do let us know. -
Alberto Morillo 34,451 Reputation points MVP2024-12-17T16:03:37.7766667+00:00 The question was answered on this forum thread on Stack Overflow web site
-
Sai Raghunadh M 1,760 Reputation points Microsoft Vendor
2024-12-17T18:04:58.7733333+00:00 Thank you for informing.
Sign in to comment
1 answer
Sort by: Most helpful
-
Alberto Morillo 34,451 Reputation points MVP
2024-12-13T19:35:23.75+00:00 -
Oury Ba-MSFT 20,171 Reputation points Microsoft Employee2024-12-13T20:09:38.85+00:00 Gopal Annasundaram Thank you for reaching out.
In addition to @Alberto Morillo 's answer please do also find below some additional docs that could also be helpful.
https://learn.microsoft.com/en-us/fabric/data-factory/tutorial-load-data-lakehouse-transform
https://learn.microsoft.com/en-us/fabric/data-factory/tutorial-move-data-lakehouse-pipeline
-
Sai Raghunadh M 1,760 Reputation points Microsoft Vendor
2024-12-17T02:46:06.52+00:00 Just checking in to see if the above answer provided by Alberto Morillo helped.
If this answers your query, do click
Accept AnswerandYesfor was this answer helpful. And, if you have any further query do let us know.
Sign in to comment -