Connect your Databricks

In order to connect your Databricks instance, Whaly needs some credentials. This guide will details the necessary steps:

1. Getting your SQL Warehouse JDBC URL

2. Creation of a Personal Token

Prerequisites

To connect Databricks to Whaly, you need the following:

• A Databricks Workspace with SQL support (premium and enterprise plans)

• A SQL Warehouse

• Admin rights on the Databricks Workspace

Getting your SQL Warehouse JDBC URL

In order to connect to your Databricks Workspace, Whaly will need a SQL Warehouse and its JDBC URL:

• Go your Workspace home page

• In the left panel, select "SQL" to enter the SQL space of your Workspace

• Once in the SQL space, click on "SQL Warehouses" in the left panel

• In the SQL Warehouses screen, either create a dedicated Warehouse or select an existing one

• Once in a Warehouse, click on "Connection details" tab and copy the JDBC URL

Creation of a Personal Token

In order to authenticate on your Databricks Workspace, Whaly needs to have a "Personal Token". In order to create one, please follow this guide.

You can either create a Personal Token on an existing user (simpler way) or create a Service principals and create the Personal Token on it (more secure way but requires doing manual API calls for setup).