Christian Harrington on 03 Nov 2023 19:08:25
The Lakehouse shortcuts are great for sure. But why can't I create some from a Warehouse? This should be available as well. Many scenarios will focus only on warehouse not lakehouse.
Or make Lakehouse shortcuts available from the Warehouse? Yes I know we can query them from the Warehouse like this: Lakehouse.schema.shortcut. That works (althought the intellisense works only 50% of the time...)
But it's not the same, you don't get visibiliy on them from the warehouse, I mean from the object explorer. I can add other warehouse with button "Add Warehouse" but this doesn't persist, you need to add it each time you have a new session. (this is another idea, coming soon)
Please add shortcuts available on Warehouse as well. This would be great.
Peri Rocha (administrator)
Thanks for posting your idea. Can you further expand on the scenarios where you would use shortcuts in Data Warehouse? Data ingestion? Querying external data? Any other scenarios you could share?
- Comments (11)
RE: Lakehouse Shortcuts available in Warehouse also
One use case: It would be needed for building Power BI direct lake reports on the Data Warehouse.As it is now, we need to copy the data into a warehouse table to show it as a table in the warehouse semantic model.If we could use shortcuts in the data warehouse then we would not need to duplicate data.