Links

Connect your Databricks

In order to connect your Databricks instance, Whaly needs some credentials. This guide will details the necessary steps:
  1. 1.
    Getting your SQL Warehouse JDBC URL
  2. 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).