I have an idea to create Warehouse that contain master table that will be use and combine within another workspace, but I can't find a way to create semantic model that can combine table from different warehouse.

Can I use notebook to write or create table in Warehouse?

Any know how to do RLS/OLS in Lakehouse?

We are architecting our data platform with Fabric. We are using medallion architecture. I have constructed the bronze and silver layer with lake houses. But I am now stuck and unclear if I should create a lake house or warehouse for the gold layer. Any advice? @Will Needham

I have project that will use Microsoft Fabric to implement Medallion architecture. Bronze: Fabric Lakehouse Silver: Fabric Lakehouse Gold: Use Data Warehouse There are requirements to do RLS/OLS/Masking to the table while also need RLS to working on report aswell . The problem is when create semantic model from the table that already applied security it will be fall back from Direct Lake to Direct Query. I still need Direct Lake Mode working while have RLS/OLS/Masking when user query table through SQL Can anyone suggest me what should I do with this scenario?