Page Comparison

The Kyvos 20232024.5 2 release support for Databricks SQL warehouse to enable the execution of ROLAP queries.

Panel

Note

Supported only with premium workspace.
Supported only with Personal Access Token authentication.
On storage, Storage Blob Data Contributor rights are required for the logged-in user.
You must have permission to create (and map) Storage credentials and External Locations for the Unity Catalog.

...

To create Databricks SQL warehouse, refer to Microsoft Documentation.

...

Open Databricks workspace.
Click your username in the top bar of the workspace and select Admin Settings from the list.
Click the SQL Warehouse Settings tab.
In the SQL Configuration Parameters textbox, specify the below key-value pair:
LEGACY_TIME_PARSER_POLICY LEGACY
Click Save.
For more information, see the SQL configuration parameters and Legacy_Time_Parser_Policy

Panel

You can modifying the existing default Datalake connection by selecting the SQL engine as Database SQL Warehouse .
See the Provider parameters table for details.
1. Enter Databricks SQL Warehouse JDBC URL. For more information, see Microsoft documentation.
2. Enter Databricks SQL Personal Access Token for the Databricks SQL workspace.
  NOTE: It is optional in the absence of this PAT. The system will attempt to connect using the PAT provided for the Databricks connection.
3. Select the Catalog Enabled checkbox. It is mandatory to enabled it for Databricks SQL.
You can also create a new build and read connection by using the SQL engine as Database SQL Warehouse. To do this, refer to the section, as explained below.

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 BUILD Warehouse option.
From the Provider list, select the Databricks option, and provide the following:
Databricks Cluster Id: Enter the ID of your Databricks cluster.
To obtain this ID, click the Cluster Name on the Clusters page in Databricks. The page URL shows <https://<databricks-instance>/#/settings/clusters/<cluster-id>
Databricks Service Address: Enter the URL of your Databricks workspace.

Databricks Personal Access Token:

Enter the personal access token to access and connect to your Databricks workspace. Refer to the

to get your token

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.Select the SQL engine as Database SQL Warehouse .See the Provider parameters table for details.
1. Enter Databricks SQL Warehouse JDBC URL. For more information, see Microsoft documentation.
2. Enter Databricks SQL Personal Access Token for the Databricks SQL workspace.
  NOTE: It is optional in the absence of this PAT. The system will attempt to connect using the PAT provided for the Databricks connection.
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.

...

Versions Compared