From the course: Advanced Microsoft Fabric Implementation and Governance
Unlock the full course today
Join today to access over 24,700 courses taught by industry experts.
Solution: Demonstrating data masking
From the course: Advanced Microsoft Fabric Implementation and Governance
Solution: Demonstrating data masking
(gentle upbeat music) - [Instructor] In the previous video, I demonstrated how to implement data masking using SQL Server Management Studio. So this time I'll demonstrate how to do it using SQL Endpoint inside a fabric. I'm going to go to my workspace and then select my SQL Analytics endpoint. I'm going to go ahead and create a new SQL query and I'm just going to select top 10 from customer. And we can see my customer data here. Now let's create the query that we need to mass the data for Customer City. I'm going to go ahead and paste that query here. Notice that what I want to make sure that I do is I want to make sure that I've got the name right, so I'm going to drag that over. So it's going to select the appropriate name for me. Case does matter. So at the fact that it's provided me, the source means for sure that I'm not going to have any issues with this. I'm going to go ahead and highlight this and say that I want to run it and it did my total execution time. I'm going to have…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
(Locked)
Data warehouse or lakehouse2m 10s
-
(Locked)
Integrating Azure security and Fabric data security2m 32s
-
(Locked)
Implementing database security2m 31s
-
(Locked)
Data masking4m 16s
-
(Locked)
Improving query performance for lakehouses and warehouses3m 12s
-
(Locked)
Challenge: Implement data masking56s
-
(Locked)
Solution: Demonstrating data masking2m 15s
-
(Locked)
-
-
-