https://community.databricks.com/t5/data-engineering/lakehouse-federation-for-sql-server-and-security-policy/m-p/66002#M32984 <P>We've been able to setup a Foreign Catalog using the following documentation:<BR /><A href="https://learn.microsoft.com/en-us/azure/databricks/query-federation/sql-server" target="_blank">https://learn.microsoft.com/en-us/azure/databricks/query-federation/sql-server</A></P><P>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?<BR />I can confirm that once disabling the Security Policy I was able to see the relevant data in the table.</P><P>The Security Policy is setup using SUSER_NAME().</P> Wed, 10 Apr 2024 13:48:21 GMT marcuskw 2024-04-10T13:48:21Z https://community.databricks.com/t5/data-engineering/lakehouse-federation-for-sql-server-and-security-policy/m-p/66002#M32984 <P>We've been able to setup a Foreign Catalog using the following documentation:<BR /><A href="https://learn.microsoft.com/en-us/azure/databricks/query-federation/sql-server" target="_blank">https://learn.microsoft.com/en-us/azure/databricks/query-federation/sql-server</A></P><P>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?<BR />I can confirm that once disabling the Security Policy I was able to see the relevant data in the table.</P><P>The Security Policy is setup using SUSER_NAME().</P> Wed, 10 Apr 2024 13:48:21 GMT https://community.databricks.com/t5/data-engineering/lakehouse-federation-for-sql-server-and-security-policy/m-p/66002#M32984 marcuskw 2024-04-10T13:48:21Z https://community.databricks.com/t5/data-engineering/lakehouse-federation-for-sql-server-and-security-policy/m-p/66005#M32985 <P>Was a bit quick here, found out that the SUSER_NAME() of the query is of course the connection that was setup.<BR />So the User/Password defined here:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Skjermbilde 2024-04-10 161751.png" style="width: 400px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/7005iF2E1D0946601678C/image-size/medium/is-moderation-mode/true?v=v2&amp;px=400" role="button" title="Skjermbilde 2024-04-10 161751.png" alt="Skjermbilde 2024-04-10 161751.png" /></span></P><P>Once I added that same user to the RLS logic I get the correct result.</P><P> </P> Wed, 10 Apr 2024 14:20:19 GMT https://community.databricks.com/t5/data-engineering/lakehouse-federation-for-sql-server-and-security-policy/m-p/66005#M32985 marcuskw 2024-04-10T14:20:19Z