Forum Discussion
Lakehouse - Shortcut questions
So based on my testing:
- Lakehouse tables don't support hyphens, only underscores, so if your shortcut is named with a hyphen then it doesn't get registered as a table
- Great, here's hoping we get more comprehensive functionality
- I'm unsure of any metadata within the lakehouse itself, but when you create a shortcut to an external resource (ADLS, S3) it either uses or registers a new cloud connection. To view the connections:
- Click on Settings (gear icon top-right of fabric/power bi portal)
- Click Manage Connections and Gateways
- On the Connections tab are all the various connections including the connections made when registering shortcuts. ADLS will be of Connection Type Azure Data Lake Storage Gen2
- It doesn't show what shortcuts are using what connections though, so may be of limited use
Most Valuable ProfessionalSo based on my testing:
- Lakehouse tables don't support hyphens, only underscores, so if your shortcut is named with a hyphen then it doesn't get registered as a table
- Great, here's hoping we get more comprehensive functionality
- I'm unsure of any metadata within the lakehouse itself, but when you create a shortcut to an external resource (ADLS, S3) it either uses or registers a new cloud connection. To view the connections:
- Click on Settings (gear icon top-right of fabric/power bi portal)
- Click Manage Connections and Gateways
- On the Connections tab are all the various connections including the connections made when registering shortcuts. ADLS will be of Connection Type Azure Data Lake Storage Gen2
- It doesn't show what shortcuts are using what connections though, so may be of limited use
Hi Anonymous ,
Thanks for using Fabric Community.
1) The reason why some of the table shortcuts are marked as unidentified is because of the type of the table. If you create a shortcut for delta tables, they will be placed under the tables section. But if you create shortcuts for CSV or parquet tables, they will be moved to Unidentified folder.
You can only use shortcuts to access data in Delta Lake format. We strongly recommend that you use Delta Lake as your primary format for storing data. However, if you have data in other formats, such as Parquet, you need to convert them to Delta Lake to leverage Fabric warehouse and shortcuts.
2) Currently renaming a shortcut is not available in Fabric. Apologies for the inconvenience.
3) At present, the underlying path for a shortcut is not exposed in Fabric. But we can certainly keep an eye for upvote.
Appreciate if you could share the feedback on our feedback link , which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.
Feedback Link : Home (microsoft.com)
You can refer to this link for more information: Shortcuts
Hope this helps. Please let us know if you have any further queries.
- AndyDDC
I believe the OP stated that the remote folder was a delta folder. In this instance, I believe it's not registering the table as the shortcut name has a hyphen in it, lakehouse tables cannot be named with a hyphen.
Hi there,
I have quite a similar problem - I'm creating a Shortcut in a Silver Layer Lakehouse (LH2), refering to another Bronze Lakehouse (LH1) in the same workspace. The shortcut points to the managed part/ table section of LH1 - where I have a delta table format, resulting from a copy activity via pipeline & a Notebook run:
Until some months ago, I was able to create a shortcut via user interface, but now everything goes under 'Unidentified' Folder, with following error: shortcut unable to identify objects as tables. Any thoughts? Tried using only letters, but unsuccessfully.
Table in source LH1
Delta Format Table
Silver LH 2 shortcut
Error message:Thanks
