topic Re: Run a multiple %command in the same cell in Data Engineering

Run a multiple %command in the same cell

BriceBuso — Mon, 17 Jul 2023 15:43:35 GMT

Hello,

is there a way to run multiple %command in a same cell ?

I heard that's not possible but would like a confirmation and maybe if it could be an idea for future updates.

Moreover, is there a way to mask the output of cells (especially markdown) when using %run. I would like to keep some documentation in the notebook executed with the %run command but not prompt it in the destination notebook.

Thanks

Re: Run a multiple %command in the same cell

Tharun-Kumar — Mon, 17 Jul 2023 17:08:22 GMT

@BriceBuso

No, we cannot have multiple %command in the same cell.

About your other question, could you try using dbutils.notebook.run(). This would also provide the possibility of providing optional parameters to the child notebook. More details are available here - https://docs.databricks.com/notebooks/notebook-workflows.html

Re: Run a multiple %command in the same cell

Anonymous — Tue, 18 Jul 2023 03:44:53 GMT

Hi @BriceBuso

Hope all is well! Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help.

We'd love to hear from you.

Thanks!

Re: Run a multiple %command in the same cell

dream — Tue, 18 Jul 2023 05:08:25 GMT

just a slight correction but you can also pass parameters when using %run