Forum Discussion

afbraga66's avatar
afbraga66
Icon for Helper III rankHelper III
10 months ago
Solved

One Lake Security implementation doubts

Hey,   So am trying to identify how to implement One Lake Security. The goal is to provided self-service for departments which will have each their own workspace, by allowing them access throught s...
governance
one lake
security
  • V-yubandi-msft's avatar
    V-yubandi-msft
    10 months ago

    Hi afbraga66 ,
    If you need RLS to function properly, ensure your queries are run through the SQL Endpoint.
    When using a notebook, use %sql for queries that require RLS, as standard Spark reads (spark.read) do not enforce it yet.

     

    Thanks for your time.

afbraga66's avatar
afbraga66
Icon for Helper III rankHelper III
10 months ago

Hey,

 

It is still not clear to me how is a user supposed to run spark notebooks and have the rls be applied, if a viewer user cannot run queries. Thank you.

 

Best regards,

Andre

V-yubandi-msft's avatar
V-yubandi-msft
Icon for Community Support rankCommunity Support
10 months ago

Hi afbraga66 ,
If you need RLS to function properly, ensure your queries are run through the SQL Endpoint.
When using a notebook, use %sql for queries that require RLS, as standard Spark reads (spark.read) do not enforce it yet.

 

Thanks for your time.