Shortcut List using spark in Notebooks

[PAC8309]

Hello,

I would like to know if it is possible to get a list using spark in notebook of all shorcut tables in a specific lakehouse without using the API (OneLake Shortcuts - List Shortcuts - REST API (Core) | Microsoft Learn)

thanks!

[Vinodh247 · Accepted solution]

Fabric currently does not expose a builtin spark method or metadata table that allows you to list OneLake shortcuts directly frm a spark notebook within a Lakehouse. The officially supported way to list shortcuts is through the REST API (list shortcuts core API) that you referenced. If you list tables using spark.catalog.listTables(), this will only show the managed or external tables registered in the metastore & not the shortcuts unless those they are mounted and registered as tables. As a workaround you can maintain a metadata table manually in your Lakehouse listing shortcuts & use the REST API externally (via Fabric Notebook using requests with access_token) and write the results to a Delta table for downstream use.

[suparnababu8]

Hi @PAC8309  

I don't think it's possible without using API's as of now. You can  submit your Idea here: Fabric Ideas - Microsoft Fabric CommunityIf you get enough votes, Micorsoft ppl will implement this in future.

Thank you!!!