topic Re: Can I run one notebook from another notebook? in Data Engineering

Can I run one notebook from another notebook?

__Databricks_Su — Wed, 18 Feb 2015 21:26:49 GMT

Re: Can I run one notebook from another notebook?

__Databricks_Su — Wed, 18 Feb 2015 21:26:50 GMT

Sure. Use the %run syntax as follows:

%run /PoundInclude

The target notebook does not need to be attached to a cluster. It will get pulled into the caller's context.

At this time, you can't combine Scala and Python notebooks, but you can combine Scala+SQL and Python+SQL notebooks.

You must specify the fully-qualified notebook from the root of the Workspace. Relative paths are not supported at this time.

If you have spaces in your notebook name, you'll need to surround the target of %run with quotes as follows:

%run "/PoundInclude (Python)"

Re: Can I run one notebook from another notebook?

sugreevchawla — Mon, 23 Mar 2015 22:47:09 GMT

I'm missing something obvious here, I'm running %run 'notebook2' inside 'notebook1' where both notebooks are in the main Workspace directory and receiving the error:

ERROR: File

u'notebook2.py'

not found.

Is there a path setting I forgot?

Thanks

Re: Can I run one notebook from another notebook?

JeffPang — Thu, 26 Mar 2015 03:26:42 GMT

Try running the %run in a new cell. There can't be any other code in the same cell performing the %run. You can still use the results of the %run in subsequent cells.

Re: Can I run one notebook from another notebook?

HananShteingar1 — Fri, 20 May 2016 12:22:03 GMT

I also have the same issue. I don't have any other code in the cell.

Re: Can I run one notebook from another notebook?

SamKlingner — Fri, 28 Oct 2016 13:21:33 GMT

Bit late: even comments can cause this issue

Re: Can I run one notebook from another notebook?

RogerErens — Tue, 07 Feb 2017 22:03:38 GMT

@hshteingart @sugreevc

Does including the notebook file extension help you, e.g.

%run my_other_notebook.ipynb

Re: Can I run one notebook from another notebook?

JosiahYoder — Thu, 10 Aug 2017 15:54:22 GMT

You can now use relative paths, e.g. %run "./PoundInclude (Python)"

Re: Can I run one notebook from another notebook?

jayashree — Mon, 14 May 2018 07:52:27 GMT

I want to run an existing notebook from another R notebook.

Re: Can I run one notebook from another notebook?

VinayakBhardwaj — Wed, 08 Aug 2018 08:10:44 GMT

dbutils.notebook.run("notebook_name", time(in sec) ,{ " "db_name" : "jmdc_20180731_test"}) @Christian Rodriguez @jayashree @Roger Erens

For example:

dbutils.notebook.run("notebook_1", 600,{ "db_name" : "jmdc_20180731_test"})

Please let me know if you do have any issues.

Mail id : vinayakbhrdwj@gmail.com

Re: Can I run one notebook from another notebook?

manishtangudu — Wed, 05 Dec 2018 10:40:20 GMT

How do I make the notebook run in a different window on calling? @Roger Erens

Re: Can I run one notebook from another notebook?

amanpreetkaur — Fri, 03 May 2019 07:15:47 GMT

Is it possible to import a particular function using %run statement in azure databricks?

Re: Can I run one notebook from another notebook?

PRABHATKUMAR — Fri, 31 May 2019 13:26:06 GMT

Yes we can import all things (functions,variables etc) from one notebook to another notebook...

Just remember to run %run /Users/path/Notebook_Name in a separate cell

and then you can call one notebook functions in another one @amanpreet kaur

Re: Can I run one notebook from another notebook?

amanpreetkaur — Mon, 03 Jun 2019 06:20:54 GMT

Is it possible to do something like this: %run /Users/path/Notebook_Name Function_Name ?

@Prabhu4284

Re: Can I run one notebook from another notebook?

MaheshGupta — Fri, 30 Aug 2019 11:12:13 GMT

How to call function of notebook_name from let say calling notebook.can you give an example for that use case

Re: Can I run one notebook from another notebook?

reportmort — Mon, 11 Nov 2019 00:08:41 GMT

@Prabhu4284 When I run Notebook B (which defines a function) it is still not defined in Notebook A. Are you sure we can import all things (functions, variables, etc.)? It appears from the Databricks documentation that only strings can be shared between Notebooks and pointers to data.

Re: Can I run one notebook from another notebook?

ashok_k_gupta12 — Sat, 03 Oct 2020 14:53:13 GMT

I declared a function in notebook commonFunction and called it from other function just by giving this command:

%run ./CommonFunction

I went ahead and used the function defiend in other notebook

infact o could access the variable defined in other notebook and vise versa too.

Re: Can I run one notebook from another notebook?

ashok_k_gupta12 — Sat, 03 Oct 2020 19:55:27 GMT

https://youtu.be/QpsSYxRg8G8

Re: Can I run one notebook from another notebook?

Makeetelich92 — Thu, 10 Jun 2021 05:22:14 GMT

I have a programming background so restarting my kernel every and running things top to bottom was always common sense to me. I do agree though that it can be misleading and people may not make that assumption. I think one flaw with his programming style at the end that notebooks solve is having the history of how you checked your data throughout the process.

Re: Can I run one notebook from another notebook?

carlitoscanas — Wed, 28 Jun 2023 23:16:07 GMT

Of course you can, in your primary notebook, use the %run magic command followed by the path or name of the notebook file you want to run, like this:

%run /path/to/other_notebook.ipynb