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

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…

Contents