Advanced Cell Magics

📄️ The %run Magic

The %run magic executes another notebook in your current kernel's namespace. After it returns, every variable, function, and import defined by the executed notebook is available in your current notebook as if you had typed those cells yourself. It's the standard tool for sharing setup or helper code across notebooks without duplicating it.

📄️ Using %sql Magic in Syntasa Notebooks

The %sql magic command allows you to execute Spark SQL queries directly within your Python or Scala notebooks. It provides a seamless way to interact with your data using SQL syntax while maintaining the ability to use the results in subsequent code cells.