Lakehouse Federation for SQL Server and Security Policy

[marcuskw]

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

[marcuskw · Accepted solution]

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:

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