Using dbt item cross workspaces
Hi, I want to use dbt job item as my ELT engine in Fabric, but I'm facing the following:
I need to read data from a bronze workspace lakehouse and write the data into a silver workspace warehouse. As I understand it now, there is no way to connect the dbt job item to a lakehouse that is in a different workspace. So I've come up with having an additional Lakehouse in the silver workspace, that acts just a a shortcut hub for the objects that i want to read with dbt.
However, this seems like an obvious antipattern as it creates unneccesary objects across my architecture. Is this really the way to do it now or is there something I'm missing?
Having the entire medaillon in a single workspace unfortunately isn't an option.
Is the cross-workspace connectivity on the roadmap for dbt job item? I need to make a decision for the data transformation engine soon and this might kill my dbt argument.
Thanks a lot!