Adding queries in your Jupyter notebooks

Now that you’ve created your notebook, it is time to add code. Jupyter notebooks in Azure Data Studio support a variety of code languages, including SQL, Python, and R. It is beyond the scope of this book to delve into languages beyond SQL. However, you should be aware that notebooks support a variety of workloads throughout the Azure data ecosystem, particularly in Synapse Analytics.

There are a few steps to go through to get our SQL working as code in our notebooks.

Figure 13.8 – Notebook toolbar

Before we delve into adding code specifically, let’s do a quick review of the options available in the header of your notebook as shown in the previous screenshot:

1. Cell provides the option to add a text or code cell to your notebook.
2. The Run all option will run all the code in sequence in your notebook.
3. Kernel specifies which language is the primary language of your notebook. In...