Notbook name dynamic to %run

HimaBindu Kalwakunta (INFOSYS LIMITED) 6

how to pass notebook name dynamically to %run magic command

1 answer

ShaikMaheer-MSFT 38,401 Reputation points Microsoft Employee

2022-10-28T16:16:41.873+00:00
Hi @HimaBindu Kalwakunta (INFOSYS LIMITED) ,

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.

%run command to reference another notebook with in current notebook in Azure Synapse Analytics

run() function of notebook module in MSSparkUtils package in Azure Synapse

Parameterize Synapse notebook in Azure Synapse Analytics

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
Please sign in to rate this answer.
HimaBindu Kalwakunta (INFOSYS LIMITED) 6 Reputation points

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,401 Reputation points Microsoft Employee

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

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

Share via

Notbook name dynamic to %run

1 answer