If you have an existing hub and spoke architecture, moving your architecture to Fabric may not be as difficult as you might initially think. One of the coolest features in Fabric is shortcuts. Shortcuts allow you to access your data that is stored in delta format (in a data lake on ADLS, S3, or OneLake) and define tables in a new lakehouse. What adds to the versatility of shortcuts is two features unique to Fabric: 1.) all data (including the data in your warehouse artifacts) is stored in open delta format and 2.) shortcuts can be created across workspaces and can point to your warehouse data that is stored as delta files.
If you don’t have major transformational needs between your warehouse and a datamart, a shortcut might be enough to allow users to begin working with the data. Of course, you can always do transformations within your warehouse and then expose just the transformed data in other lakehouses on a table-by-table basis. In the below video, I walk you through the very simple steps to setup shortcuts. Hopefully, you can see the versatility of shortcuts and can begin putting them to use for your specific scenarios.