topic Re: dbutils or other magic way to get notebook name or cell title inside notebook cell in Data Engineering

dbutils or other magic way to get notebook name or cell title inside notebook cell

Hubert-Dudek — Wed, 17 Nov 2021 14:16:14 GMT

Not sure it exists but maybe there is some trick to get directly from python code:

NotebookName
CellTitle

just working on some logger script shared between notebooks and it could make my life a bit easier 🙂

Re: dbutils or other magic way to get notebook name or cell title inside notebook cell

Anonymous — Wed, 17 Nov 2021 19:57:54 GMT

Hey there! Thanks for your question. We'll see what the community comes up with first. Thanks in advance for your patience!

Re: dbutils or other magic way to get notebook name or cell title inside notebook cell

-werners- — Thu, 18 Nov 2021 08:36:34 GMT

I am sure there is a trick but I doubt it is the best way:

the actual notebooks store each cell as # COMMAND ------ and markdown as # MAGIC %md.

So you could fetch the actual notebook code and start rebuilding it in python with a loop/count over COMMAND or MAGIC.

But as I said: seems overkill. Databricks can parse it nicely so there has to be a way.

Re: dbutils or other magic way to get notebook name or cell title inside notebook cell

-werners- — Thu, 18 Nov 2021 09:06:45 GMT

Maybe you can use displayHTML instead of markdown? Like that you actually have it as code:

displayHTML("insert text here").

It is not as clean as markdown though.

Re: dbutils or other magic way to get notebook name or cell title inside notebook cell

Hubert-Dudek — Thu, 18 Nov 2021 11:35:38 GMT

@Werner Stinckens I will experiment on that in few weeks using your ideas. I need it only when exception occur in notebook so maybe it will not be so big overkill. I will back to you.

Re: dbutils or other magic way to get notebook name or cell title inside notebook cell

-werners- — Thu, 18 Nov 2021 13:11:02 GMT

you could also use the log analytics of your cloud provider.

For Azure f.e. we send all databricks logs to Log Analytics. I suppose on AWS/GCP there is also a similar thing.

(https://docs.microsoft.com/en-us/azure/databricks/administration-guide/account-settings/azure-diagnostic-logs)

Or send logs to some location which you can then parse with python

(https://docs.microsoft.com/en-us/azure/databricks/clusters/configure#cluster-log-delivery)

Re: dbutils or other magic way to get notebook name or cell title inside notebook cell

jose_gonzalez — Thu, 18 Nov 2021 16:24:39 GMT

Hi @Hubert Dudek ,

The following command will print the path where your notebook is located. If you split the returned string and only select the last string, then you will be able to get the notebook name

notebook_name = dbutils.notebook.entry_point.getDbutils().notebook().getContext().notebookPath().get()

Re: dbutils or other magic way to get notebook name or cell title inside notebook cell

Hubert-Dudek — Thu, 18 Nov 2021 16:40:31 GMT

wow will test it tomorrow 🙂 haven't known about dbutils.notebook.entry_point

Re: dbutils or other magic way to get notebook name or cell title inside notebook cell

jose_gonzalez — Wed, 24 Nov 2021 00:01:51 GMT

Did this helped you? if it did, could you mark it as best response?

Re: dbutils or other magic way to get notebook name or cell title inside notebook cell

Hubert-Dudek — Wed, 24 Nov 2021 11:13:39 GMT

haven't tested yet (you now tomorrow in dev world can be quite long time) but I've selected your answer as the best

Re: dbutils or other magic way to get notebook name or cell title inside notebook cell

Anonymous — Wed, 24 Nov 2021 13:19:27 GMT

@Hubert Dudek - If I haven't told you, you are awesome!

Re: dbutils or other magic way to get notebook name or cell title inside notebook cell

Hubert-Dudek — Wed, 24 Nov 2021 13:20:30 GMT

Thank you. You too 🙂

Re: dbutils or other magic way to get notebook name or cell title inside notebook cell

rtullis — Thu, 21 Nov 2024 20:22:16 GMT

I got the solution to work in terms of printing the notebook that I was running; however, what if you have notebook A that calls a function that prints the notebook name, and you run notebook B that %runs notebook A? I get the notebook B's name when I want notebook A's name. Any suggestions?

Re: dbutils or other magic way to get notebook name or cell title inside notebook cell

montoyesco — Thu, 13 Nov 2025 17:05:34 GMT

Do you know how can I capture the title of the cell using code?

Re: dbutils or other magic way to get notebook name or cell title inside notebook cell

montoyesco — Thu, 13 Nov 2025 17:14:42 GMT

The code from jose_gonzalez captures the notebook name only. I need to capture the cell title (see screenshot).