cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results for 
Search instead for 
Did you mean: 

Lakehouse Federation for SQL Server and Security Policy

marcuskw
Contributor

We've been able to setup a Foreign Catalog using the following documentation:
https://learn.microsoft.com/en-us/azure/databricks/query-federation/sql-server

However the tables that have RLS using a Security Policy appear empty. I imagine that this solution is not able to use the Functions and respective Security Policy?
I can confirm that once disabling the Security Policy I was able to see the relevant data in the table.

The Security Policy is setup using SUSER_NAME().

1 ACCEPTED SOLUTION

Accepted Solutions

marcuskw
Contributor

Was a bit quick here, found out that the SUSER_NAME() of the query is of course the connection that was setup.
So the User/Password defined here:

Skjermbilde 2024-04-10 161751.png

Once I added that same user to the RLS logic I get the correct result.

View solution in original post

1 REPLY 1

marcuskw
Contributor

Was a bit quick here, found out that the SUSER_NAME() of the query is of course the connection that was setup.
So the User/Password defined here:

Skjermbilde 2024-04-10 161751.png

Once I added that same user to the RLS logic I get the correct result.

Join 100K+ Data Experts: Register Now & Grow with Us!

Excited to expand your horizons with us? Click here to Register and begin your journey to success!

Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!