Creating SQL endpoints

SQL endpoints are computation resources using which you can run SQL queries on data objects in Azure Databricks environments. SQL endpoints are fully managed SQL-optimized compute clusters that autoscale based on user load to support a better experience for user concurrency and performance. They are computing clusters, very similar to clusters that we have already used in the Azure Databricks environment.

Getting ready

Let's go through the permissions required for creating and managing SQL endpoints in the Azure Databricks workspace.

The user must have the Allow cluster creation permission in the Azure Databricks workspace. You can check this permission from Admin Console | the Users tab or the Groups tab depending on whether access needs to be granted to an individual user or group. Refer to the following screenshot from the workspace:

Figure 8.5 – Databricks SQL cluster creation

After permission is granted...