...
Parameter/Field | Comments/Description | |
Name | Enter a unique name for the connection. | |
Category | Select the Warehouse option. There may be more than one warehouse connection. | |
Provider | Select GENERIC, and enter provider detailsDATABRICKSSQL from the list. | |
Driver class | Provide the This field will be auto selected. The Driver class (com.databricks.client.jdbc.Driver ) is required to connect to the Azure SQL DB. | |
URL | In the URL field, enter the Databricks SQL Warehouse JDBC URL. For more information, see Microsoft documentation. | |
User Name | Enter Databricks SQL Personal Access Token for the Databricks SQL workspace | |
Password | Enter Databricks SQL Personal Access Token’s value for the Databricks SQL workspace | |
Spark Read Method | Use as Source | This checkbox is auto selected. Enter Spark Read Method as JDBC |
Schema Enabled Is default SQL Engine | By default, the checkbox is selected as this connection can only be used to read data (creating datasets) on which the semantic model will be created. | |
Catalog Enabled | Select this checkbox to list different catalog created in the workspace. | |
Properties | Click Properties to view or set properties. |
After you finish configuring the settings using the table shown below the screenshot, click the Test button from the top left to validate the connection settings.
If the connection is valid, click the Save button.
...