How can we improve Microsoft Azure SQL Data Warehouse ?

Row-Level Security

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.

152 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Robert Golik shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    4 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Darryll Petrancuri commented  ·   ·  Flag as inappropriate

        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  ·   ·  Flag as inappropriate

        This would be a great feature. It would be perfect if SQL DW also support Row level security based on security groups.

      Feedback and Knowledge Base