Sign in
Log inSign up
Sandeep Pawar

889 reads

4 comments

Anand Kumar
Anand Kumar
Jan 31, 2024

Hi Sandeep, It is a good article on Shortcuts in KQL.

But do you have ideas why there is no Shortcut functionality available in Warehouse? It was avaiable in Nov 2023 time period but disappreared during GA. Now the documentation says it is only supported in Lakehouse.

When we have to load shared DIMs across different Warehouses, I have to load sepearte copies - breaking the whole One Copy of Data Fabric marketing point! Options: Create Views: Direct Lake connections falls back to Direct Query when using Views Clone tables: Need to create everyday thus will break Semantic layer relationships.

What do you suggest follow to load shared DIMs across different Warehouses?

·
Sandeep Pawar
Sandeep Pawar
Author
·Mar 3, 2024

Hi Anand, you can't create shortcuts in a WH. You can add Dims from different WH/LH to a LH and then create a DL model on top of that.

·
Hans
Hans
Sep 6, 2024

Hi. Interesting article. Did you also try to create a shortcut to a Kusto DB that is already a shortcut from an ADX shortcut? In a lakehouse I'm trying to shortcut a Kusto Database. That Kusto database is a shortcut to a Azure ADX Kusto database. Even if I activate onelake paths, add the shortcut half an hour later, the table list is empty.

·
AZIZ Quazi
AZIZ Quazi
Sep 26, 2024

Q: Can we create shortcuts in a Lakehouse that point to tables in a Warehouse? I mean, how do we get data from a WH to an LH? I'd appreciate any documentation link. Thanks.

·