Notbook name dynamic to %run

Question

Notbook name dynamic to %run

73745420 6 Microsoft External Staff

Hi

how to pass notebook name dynamically to %run magic command

1 answer

Your answer

Answer 1

ShaikMaheer-MSFT 38,551 Microsoft Employee Moderator

Hi @73745420 ,

Thank you for posting query in Microsoft Q&A Platform.

Using %run command we cannot do that.

You can consider using mssparkutils.notebook.run() function to run another notebook by dynamically passing notebook name using variables or parameters.

Below are few useful videos for reference.

Hope this helps. Please let me know if any further queries.

Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
Want a reminder to come back and check responses? Here is how to subscribe to a notification

73745420 6 Reputation points Microsoft External Staff

2022-10-28T19:51:40.87+00:00

Hi Maheer

Thank you for your response .But i want to use magic command only because if we use sparkutils we can't call called(child) notebook methods in caller notebook right?

1.Notebook1
def greet()
print("hi")

2.Notebook2

case1. if we use
mssparkutils.notebook.run("Notebook1,90,{}) // It will run seperate job

so if we try call greet() in Notebook1 it will through error

case2;if we use %run Notebook1
and if we calll greet() it will print hi so i want to use %run and want to pass notebook name dynamically

case3.If it only possbile through mssparkutils then how to callgreet()? please help
ShaikMaheer-MSFT 38,551 Reputation points Microsoft Employee Moderator

2022-11-21T05:01:16.657+00:00

Got you. Unfortunately, at this moment we cannot dynamically pass notebook names to %run command.

Share via

Notbook name dynamic to %run

1 answer

Your answer