Data Sources
Databricks
Overview
AI Squared enables you to transfer data from Databricks to various destinations by using Open Database Connectivity (ODBC). This guide explains how to obtain your Databricks cluster’s ODBC URL and connect to AI Squared using your credentials. Follow the instructions to efficiently link your Databricks data with downstream platforms.Setup
1
Open workspace
In your Databricks account, navigate to the “Workspaces” page, choose the desired workspace, and click Open workspace
2
Go to warehouse
In your workspace, go the SQL warehouses and click on the relevant warehouse
3
Get connection details
Go to the Connection details section.This tab shows your cluster’s Server Hostname, Port, and HTTP Path, essential for connecting to AI Squared
4
Create personal token
Then click on the create a personal token link to generate the personal access token
Configuration
| Field | Description |
|---|---|
| Server Hostname | Visit the Databricks web console, locate your cluster, click for Advanced options, and go to the JDBC/ODBC tab to find your server hostname. |
| Port | The default port is 443, although it might vary. |
| HTTP Path | For the HTTP Path, repeat the steps for Server Hostname and Port. |
| Catalog | Database catalog |
| Schema | The initial schema to use when connecting. |