Forum Discussion

wardy912's avatar
wardy912
Super User
3 months ago
Solved

Warehouse security when using Direct Lake models

Hi Everyone,    I have a warehouse that contains 2 schemas, support and finance. I've built 2 Direct Lake models using the OneLake connector. I am using item level permissions to ensure securi...
data warehouse
Warehouse
  • wardy912's avatar
    wardy912
    3 months ago

    I have received information from the OneLake security team stating that they are actively working on a warehouse solution. In the meantime, I'll need to create a separate warehouse for each schema to ensure security.

wardy912's avatar
wardy912
Super User
3 months ago

Thanks tayloramy ,

 

 That makes sense, it's too late to go back to SQL endpoint now.
ReadAll seems to be essential to use onelake connection.

tayloramy's avatar
tayloramy
Super User
3 months ago

Hi wardy912, 

 

Yeah, security on warehouses leaves something to be desired for sure. 

For this reason I tend to use Lakehouses for all my stuff, then you can use OneLake Security and everything is fairly consistent.