Get name of Fabric workspace

[Mnnleus]

Hello, 

I would like to retrieve the name of my workspace through a notebook, but this code doesn't work: spark.conf.get("trident.workspace.name")
Then this one works very well: spark.conf.get("trident.workspace.id")
Is it in preview or do you have to use another function?

Thank you in advance for your answers

[deborshi_nag]

Hello @Mnnleus 

from notebookutils import mssparkutils

print(mssparkutils.env.getWorkspaceName())

[chetanhiwale]

hi @Mnnleus , 

This works now. 
Code : 

spark.conf.get("trident.workspace.name")

[aidan959]

Hey @Mnnleus ,

Have found workaround -  the proposed "solution" (this is "not possible" 😒) is pretty unhelpful.

This code queries the fabric api for the workspace name taking the workspace ID from configuration. Should work if copy and pasted in.

 import sempy.fabric as fabric
 workspace_id = spark.conf.get("trident.workspace.id")
 workspace = fabric.FabricRestClient().get(f"/v1/workspaces/{workspace_id}").json()["displayName"]

[12angrymentiger]

This has broken some of my pipelines as I relied on this spark config. Hopefully this gets resolved soon or there is another fix in place.

[Mnnleus]

Hi @Anonymous,

thank you for your answer

[Anonymous]

Hi @Mnnleus 
Glad that your query got resolved. Please continue using Fabric Community for any help regarding your queries.

[Anonymous · Accepted solution]

Hi  @Mnnleus 
Thanks for using Fabric Community.
Currently there is no spark config that stores the workspace name. spark.config.get("trident.workspace.name") used to work before, but is not available now.

Hope this helps. Please let me know if you have any further questions.