...
To create Azure SQL Warehouse connection for sanity suite, perform the following steps.
...
Name – AzuredatabricksSQL
...
Category - WAREHOUSE
...
Providers- GENRIC
...
Parameter | Description |
|---|---|
Name | Enter a name for sanity connection. |
Category | Select the Warehouse option. |
Provider | Select the Generic option. |
Driver | Enter the Driver class as com.databricks.client.jdbc. |
...
Driver | |
URL | Enter URL |
...
as: jdbc:databricks://adb-650081446221384.4.azuredatabricks.net:443/default;transportMode=http;ssl=1;AuthMech=3;httpPath=/sql/1.0/warehouses/3bc903419b85ed62 |
Username |
...
Password – databircks token
...
Spark ReadMethod = JDBC
...
Enter Databricks token. | |
Password | Enter Databricks token. |
Authentication Type | Select the Snowflake option. |
Spark ReadMethod | Select JDBC |
Schema Enabled | Select this checkbox to enable schema. |
Is Default SQL Engine | To enable the connection for raw data, click the Is Default SQL Engine checkbox to set this connection to run the default SQL engine. |
Properties | Click Properties to view or set properties. |