Forum Discussion
Notebook load data from a Lakehouse that's not default
Hey all, I've loaded my sources and my medallion stages into their own lakehouses for scalability and trying to keep things tidy from the get-go. I'm now in a position where it would be REALLY us...
The medallion architecture suggests to have different zones within a lokehouse.
If I understand your issue, you could create the file strcuture (zones) within workspae and in the same lakehouse.
Having a single lakehouse with all layers contained within it goes against the access and security suggestions. Individual lakehouses in their own workspace allow for role based / workspace access permissions, keeping bronze safe, Silver accessible to data scientists and gold accessible to reporting analysts.
The solution I've been given for this from microsoft was to do shortcuts to the active lakehouse for any data I want to read in. Writing out can be done from anywhere.