Forum Discussion
Fabric Shortcut based on a view
Hi schou,
I mean the source is data warehouse from other workspace, when you use Lakehouse as source, it only lists the table and files.
If you are not so sure how to move data, you can create a dataflow or data pipeline to move data from Lakehouse to the data warehouse which hosted in the same workspace.
Then you can create a data pipeline to move data from another workspace warehouse to the current workspace Lakehouse. (when you choose warehouse as source, it will detect the list of all the tables and views under the table option.Sourcedestination
Regards,
Xiaoxin Sheng
Your understanding is correct as only files/tables can be leveraged for shortcut creation and not the views.
You would have to materilize the views as tables for you to use that as a shortcut as of today
NandanHegde thanks for confirming!
what would you suggest to do to make the views as tables?
There are data pipelines which can connect to lakehouses and you can map that as a table