Dynamic Data Masking in Microsoft Fabric

[@franciscoanalytics]

Hey! Great video! Is it possible to use dynamic data masking for contributor users?

[@DataBar]

Any user with Admin, Contributor, or Member permissions on the workspace will be able to see unmasked data. If you need it to be masked for a user, either give the Viewer workspace role, or grant more granular SQL permissions using the GRANT statement.

[@jideraheem3813]

Very well put together! Many thanks. I see that you had done this implementation on DWH tables. Are masking/obfuscations currently supported on Lakehouse delta tables, please? I'd appreciate your feedback

[@DataBar]

@jideraheem3813 Dynamic data masking is supported for the SQL Analytics Endpoint on a Lakehouse. See this link: blog.fabric.microsoft.com/en-us/blog/announcing-dynamic-data-masking-for-fabric-warehouse-and-lakehouse-sql-endpoint/

[@jideraheem3813]

​@DataBar oh God! You are a star. I had wondered if you'd reply 😊. Thank you for the prompt response

[@jideraheem3813]

@@DataBar I was hoping there was a way to implement these access/security controls at the delta table-level, not the Sql endpoint.. Do you have insights on that, please?