It would be great to implement Row-Level Security on SQL Data Warehouse.
That would be a great solution for scenarios where (for example) we have clients like PowerBI using data from SQL warehouse, and persons who have limited data access.
Thanks for the suggestion. Row-level security is an important security feature for DW workloads. We hope to have more to share in the coming months. 6853066
Sebastian Roether commented
I too am very interested in this feature. Are there any updates?
Robert Durrant commented
Is there another thread for this? A couple of months to share more information ended 2 years ago.
Darryll Petrancuri commented
It's actually an obscenity Row-Level Security s not supported in Azure SQL Data Warehouse. And I think it's clear the reason is likely that Azure SQL Data Warehouse is not using a fork from the Azure SQL Database code base, which I believe is the case for SQL Server (on-premises).
How can Azure SQL Data Warehouse be touted as the cornerstone of Microsoft's MPP Cloud BI and not support such?
Håkan Winther commented
This would be a great feature. It would be perfect if SQL DW also support Row level security based on security groups.