Forum Discussion
Shortcut List using spark in Notebooks
- 1 year ago
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.
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.