In this lab you will use a built-in quickstart from Azure Databricks to connect to your Blob storage, and you will use a Microsoft Tutorial as guidelines to write data to your SQL Database.
If you don't have an Azure Databricks Workspace yet, you can follow these instructions to create one using using the Azure Portal.
Besides that, you need to make sure that you have Azure Blob Storage so that you can mount files to your Azure Databricks Workspace. If you don't know how to create a Storage Account, please follow these instructions.
Please upload the preferences.json file to your Storage Account following these instructions.
As a final prerequisite, make sure that there is a SQL Database instance that you can connect to. If you don't have it, you can follow these instructions to deploy it.
Go to your Databricks resource in the Azure Portal and select Launch Workspace to go to your Databricks Workspace.
In the Overview pane of your Databricks Workspace, select the Import & Explore Data option in the middle of the page.
Then select the Other Data Sources tab, and press Create Table in Notebook.
This will automatically prepopulate a Notebook with which you can connect to an Azure Blob Storage.
Follow the steps which are shown in this Notebook.
After Step 4, you can add new cells yourself to write this data to your SQL Database, using these instructions to guide you.