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
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.