The Kyvos 2024.2 release support for Databricks SQL warehouse to enable the execution of ROLAP queries.
Note
Supported only with premium workspace.
Supported only with Personal Access Token authentication.
The serverless type Databricks SQL Warehouse cluster will only be supported.
Unity Catalog must be enabled.
Creating Databricks SQL Warehouse connection
From the Toolbox, click Setup, then choose Connections.
From the Actions menu ( ⋮ ) click Add Connection.
Enter a Name for the connection.
From the Category drop-down list, select the Warehouse option.
From the Provider list, select the DatabricksSQL option.
The Driver Class field is prepopulated.
Enter Databricks SQL Warehouse JDBC URL. For more information, see Microsoft documentation.
Enter Username as token.
Enter Databricks SQL Personal Access Token for the Databricks SQL workspace in the Password field.
To use this connection as a read connection also, select the Use as Source checkbox.
To use this connection as the default SQL engine, select the Is Default SQL Engine checkbox.
Select the Catalog Enabled checkbox. It is mandatory to enabled it for Databricks SQL.
Click the Properties link to view or set properties.
After configuring the settings, click the Save button.
To refresh connections, click the Actions menu ( ⋮ ) at the top of the Connections column and select Refresh.
