cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results for 
Search instead for 
Did you mean: 

Can I run one notebook from another notebook?

__Databricks_Su
Contributor
 
21 REPLIES 21

__Databricks_Su
Contributor

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)"

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

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.

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

Bit late: even comments can cause this issue

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

RogerErens
New Contributor II

@hshteingart @sugreevc

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

%run my_other_notebook.ipynb

?

jayashree
New Contributor II

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

VinayakBhardwaj
New Contributor II

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

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

manishtangudu
New Contributor II

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

amanpreetkaur
New Contributor III

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

PRABHATKUMAR
New Contributor II

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

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

@Prabhu4284

Join 100K+ Data Experts: Register Now & Grow with Us!

Excited to expand your horizons with us? Click here to Register and begin your journey to success!

Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!