Skip to main content
Microsoft Idea

Synapse

Planned

Support Workspace introspection in Notebook

Vote (2) Share
Matthias Wong's profile image

Matthias Wong on 06 Oct 2023 11:49:57

in a Spark notebook, I would like to be able to call upon a Python module to introspect what is inside the workspace. For example, within a Python notebook I would like to be able to list the warehouses and lakehouses in the same workspace, as well as their OneLake path. It would be a bonus if we can create lakehouses on the fly within a notebook, but even just reading would be good.


this would allow amazing possibilities such as looping through all the lakehouses, and doing various utility things such as orchestrating a pipeline or doing some quality checks or some clean-up or something.


possible implementation method is to expand on mssparkutils. Or maybe make a new thing called msfabricutils.

Jene Zhang (administrator) on 13 Nov 2023 07:54:22

We've planned a group of lakehouse APIs in mssparkutils, notebook user will be able to get/list/create/delete/update the lakehouses through mssparkutils, we'll provide help() function to illustrate the usage as well. Thanks for the feedback, and we'll consider the data warehouse API in next round of planning.

Comments (1)
Matthias Wong's profile image Profile Picture

Mark Tuttle on 08 Oct 2023 23:41:14

RE: Support Workspace introspection in Notebook

Fantastic idea, Matthias.