Databricks and Azure SQL

How to connect SQL with Databricks ?

Prerequisites:

1. Create key-vault in SQL

2. Create secrets in key-vault

3. Create scope in Databricks using this key

Step1:

Log-in to Databricks >Create cluster

Go to Workspace > notebook

Check the secrets by using below command

You will get the scope and key from your Azure Key-vault > secrets window

If it is not showing there, check with your administrator.

Step2:

Configure the jdbc settings:

Step3:

Read the table as data frame