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).

Last modified 3mo ago