It’s amazing. We can easily create a Fabric Notebook within the LakeHouse. We do not need to do any jobs for configuration for Spark, Scala, or Python to run the script. What you need to do is just drag & drop, and then let Fabric automatically generate codes for us.

Let’s try it now to create a notebook and run some queries from Lakehouse.

1. From your workspace, open your LakeHouse. E.g, My LakeHouse name is TestLH.

2. Under Explorer, select the table FactOnlinesales > click … > open in notebook > New notebook

3. Drag & Drop the table to the existing cell & the created notebook > then Run cell.

4. You can rename your notebook to easily understand your works inside the notebook by selecting the default name of the notebook on the top left corner as below.

5. To Open in VS Code and work with the notebooksfrom your local machine, select the button Open in VS Code from the Lakehouese editor.

6. You may need to install Extension “Synapse VS Code” if it is not available in your VS Code. Just follow the guidance to complete these steps.

7. You may confront the notification that you cannot install this time as there is no the release version. However, you can install the pre-release version for testing purposes.

8. Now, you can enjoy your notebook with your PySpark and SparkSQL.