Forum Discussion
How do I organize everything?
Noeleke1301 : Thanks for the detailed meassage and it does help for community member to undestand more on the ask and they can share their ideas on this .
As you rightly said that moving the data from Operational DB to lakehouse you can use the datafactory or notebook and both should suffice the ask .
I think your idea of having the medallion architecture is the right approach , but I was thinking that if you can have the lakehouse as the department and then have folders with the name like Bronze / Silver / Gold . By doing this you will have uniformity in the data hierarchy for all the departments and also it will enable to set the permission at the lakshouse level for the users.
HTH
Thanks
Himanshu
HimanshuS-msft
Thanks for your reply once again. I indeed hope that this forum will get more active with ideas being shared on how to improve organization & architecture within Fabric.
So what you're saying is that I should make a DLH per department, for example HR. If one of my operations reports need to have a subset of this HR data, take for example 'hours worked', how would I proceed?
1) Create a shortcut in the operations DLH to the 'hours' file in the HR DLH
2) Or connect the report to the HR DLH, but how would this work with user permissions?
A second question; you mentioned I should create folders with B/S/G names, but I notices that I cannot create folders in the tables section of a DLH, only in the files section.
Does that mean that I should have all my tables start out as a file (and then create a table from then), instead of loading the table directly from say a dataflow?
Thanks so much for your insights.