topic Reference one notebook from another in Data Engineering

Reference one notebook from another

DennesTorres — Tue, 05 Dec 2023 16:08:33 GMT

Hi,

Is it possible to reference one notebook from another?

If I have some generic code used in multiple notebooks, is it possible to make an import?

Kind Regards,

Dennes

Re: Reference one notebook from another

12angrymentiger — Tue, 05 Dec 2023 16:52:15 GMT

Yes you can with 2 different methods. The first method below %run with no parameters allows you to reference any child variables in the parent notebook. The second method (mssparkutils) runs in another session so you are not allowed to see the variables in the parent notebook.

2 methods:

%run notebook_name

mssparkutils.notebook.run("path", 90, {"input": 20 })

Introduction to Microsoft Spark utilities - Azure Synapse Analytics | Microsoft Learn

Re: Reference one notebook from another

Anonymous — Tue, 05 Dec 2023 16:23:56 GMT

Hi @DennesTorres
Please refer to this link: https://learn.microsoft.com/en-us/azure/databricks/notebooks/notebook-workflows
Hope this helps.

Re: Reference one notebook from another

Anonymous — Thu, 07 Dec 2023 15:24:27 GMT

Hi @DennesTorres
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. Otherwise, will respond back with the more details and we will try to help.
Thanks