Forum Discussion
Lakehouse - Shortcut questions
I have three questions about shortcuts in a lakehouse: If a shortcut has a hyphen in the name, it will automatically be put in the "Unidentified" folder, and you can't really use them. Why does thi...
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
If you create a shortcut to a delta folder in ADLS and you give the shortcut a name with a hyphen in, then it can't register the shortcut table successfully. If the shortcut name doesn't have a hyphen in, then the table shortcut can be registered successfully.
Thanks AndyDDC for explaining the issue!
Anonymous - If hyphens are not supported, then I would expect to see a message that those are not allowed, like you would, for example, with spaces:
Also, I find it interesting that in the "Lakehouse" view (the toggle in the upper right corner), shortcuts with hyphens are put in the "Unidentified" folder:
But if I switch to "SQL endpoint" (the toggle in the upper right corner), then I am able to view the table: