> ## Documentation Index
> Fetch the complete documentation index at: https://docs.squared.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# 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

<Steps>
  <Step title="Open workspace">
    In your Databricks account, navigate to the "Workspaces" page, choose the desired workspace, and click Open workspace

    <Frame>
      <img src="https://res.cloudinary.com/dspflukeu/image/upload/v1709668680/01-select_workspace_hsovls.jpg" />
    </Frame>
  </Step>

  <Step title="Go to warehouse">
    In your workspace, go the SQL warehouses and click on the relevant warehouse

    <Frame>
      <img src="https://res.cloudinary.com/dspflukeu/image/upload/v1709669032/02-select-warehouse_kzonnt.jpg" />
    </Frame>
  </Step>

  <Step title="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

    <Frame>
      <img src="https://res.cloudinary.com/dspflukeu/image/upload/v1709669111/03_yoeixj.jpg" />
    </Frame>
  </Step>

  <Step title="Create personal token">
    Then click on the create a personal token link to generate the personal access token

    <Frame>
      <img src="https://res.cloudinary.com/dspflukeu/image/upload/v1709669164/05_p6ikgb.jpg" />
    </Frame>
  </Step>
</Steps>

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