889 reads
4 comments
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?
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.
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.
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.