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

# Databricks

Databricks is a unified data lakehouse platform for analytics and AI. Connecting Databricks to Duvo lets your agents run SQL queries against your SQL Warehouse, explore your data catalog, and pull results into automated workflows.

## Setup

<Steps>
  <Step title="Confirm prerequisites" icon="circle-check">
    <Check>A Databricks workspace with at least one running SQL Warehouse.</Check>
    <Check>A Databricks personal access token (PAT). To generate one, go to **User Settings > Developer > Access tokens** in your Databricks workspace and click **Generate new token**. Copy the token immediately — it cannot be retrieved later.</Check>
    <Check>The connection details for your SQL Warehouse. To find them, open your Databricks workspace, click **SQL Warehouses** in the sidebar, select your warehouse, and open the **Connection details** tab.</Check>

    <Tip>
      Need a token? Follow [Databricks' personal access token guide](https://docs.databricks.com/aws/en/dev-tools/auth/pat) to generate one (AWS docs; Azure and GCP have equivalent pages).
    </Tip>
  </Step>

  <Step title="Grant the required permissions" icon="key">
    The Databricks account you connect must have:

    * **Databricks SQL entitlement** — your user account must have the Databricks SQL entitlement enabled in the workspace.
    * **CAN USE** permission on the target SQL Warehouse — this is the minimum access level required to connect and run queries.
    * **Data access** — your account must have SELECT (or higher) privileges on the catalogs, schemas, and tables you want to query.

    <Warning>
      The account's privileges determine exactly what data the agent can reach. Grant SELECT (or higher) only on the catalogs, schemas, and tables the agent needs.
    </Warning>
  </Step>

  <Step title="Add the connection in Duvo" icon="plug">
    On the [Connections page](https://app.duvo.ai/integrations), open Databricks and fill in these fields:

    <ParamField body="Server Hostname" type="string" required>
      Your Databricks workspace hostname (e.g., `dbc-abc123.cloud.databricks.com`). Found on the **Connection details** tab of your SQL Warehouse.
    </ParamField>

    <ParamField body="HTTP Path" type="string" required>
      The SQL Warehouse HTTP path (e.g., `/sql/1.0/warehouses/abc123`). Found on the **Connection details** tab of your SQL Warehouse.
    </ParamField>

    <ParamField body="Personal Access Token" type="string" required>
      Your Databricks personal access token (starts with `dapi`). Generated from **User Settings > Developer > Access tokens** in your Databricks workspace.
    </ParamField>
  </Step>
</Steps>

<AccordionGroup>
  <Accordion title="Third-party documentation" icon="book">
    * [Generate a personal access token](https://docs.databricks.com/aws/en/dev-tools/auth/pat) — Step-by-step guide for creating PATs (AWS docs; Azure and GCP have equivalent pages).
    * [Get connection details for a compute resource](https://docs.databricks.com/aws/en/integrations/compute-details) — How to find your Server Hostname and HTTP Path (AWS docs; Azure and GCP have equivalent pages).
    * [SQL warehouse access control](https://docs.databricks.com/en/security/auth-authz/access-control/sql-endpoint-acl.html) — Managing CAN USE and other warehouse permissions.
  </Accordion>
</AccordionGroup>

## Capabilities

* **Run SQL queries** — Execute analytical queries directly against your Databricks SQL Warehouse and retrieve results.
* **Explore your data catalog** — Browse catalogs, schemas, and tables using discovery queries to understand available datasets.
* **Inspect table structures** — View column definitions, data types, and metadata for any table in your lakehouse.
* **Pull business metrics** — Extract KPIs, performance data, and aggregated insights for reports and downstream workflows.

## Key Benefits

* **Lakehouse access** — Query your unified data platform directly from agents without manual SQL sessions.
* **Familiar SQL interface** — Use standard SQL to retrieve exactly the data you need from structured and semi-structured sources.
* **Secure authentication** — Connects through personal access tokens with scoped permissions, keeping your data access controlled.
* **Large result handling** — Streams query results efficiently using Arrow format, supporting datasets with millions of rows.
* **Data-driven automation** — Make intelligent workflow decisions based on live lakehouse data rather than stale exports.

## Works Well With

<CardGroup cols={3}>
  <Card title="Google Sheets" icon="https://mintcdn.com/duvo-d8027998/O3tlM6eCuFk2uJpN/images/connections/google-sheets.svg?fit=max&auto=format&n=O3tlM6eCuFk2uJpN&q=85&s=0ef8d55e05c34e7a4a618933bdf0ceb3" href="/user-guide/connections/available-connections/google-sheets" width="24" height="24" data-path="images/connections/google-sheets.svg">
    Query Databricks for raw data, then push summarized results into a spreadsheet for stakeholder review.
  </Card>

  <Card title="Microsoft Excel" icon="https://mintcdn.com/duvo-d8027998/O3tlM6eCuFk2uJpN/images/connections/excel.svg?fit=max&auto=format&n=O3tlM6eCuFk2uJpN&q=85&s=986599d60d09acee47293fda2b62df99" href="/user-guide/connections/available-connections/microsoft-excel" width="2290" height="2130" data-path="images/connections/excel.svg">
    Query Databricks for raw data, then push summarized results into a spreadsheet for stakeholder review.
  </Card>

  <Card title="Slack" icon="https://mintcdn.com/duvo-d8027998/O3tlM6eCuFk2uJpN/images/connections/slack.svg?fit=max&auto=format&n=O3tlM6eCuFk2uJpN&q=85&s=8a64bdd1af39e903923e4a273b4a4618" href="/user-guide/connections/available-connections/slack" width="512" height="512" data-path="images/connections/slack.svg">
    Run scheduled analytical queries and deliver key metrics or alerts directly to your team's communication channels.
  </Card>

  <Card title="Snowflake" icon="https://mintcdn.com/duvo-d8027998/O3tlM6eCuFk2uJpN/images/connections/snowflake.svg?fit=max&auto=format&n=O3tlM6eCuFk2uJpN&q=85&s=42fbf1853c296d1876c3b1fc21a8779e" href="/user-guide/connections/available-connections/snowflake" width="16" height="16" data-path="images/connections/snowflake.svg">
    Combine data from multiple warehouse platforms in a single agent to build cross-system reports.
  </Card>

  <Card title="Google BigQuery" icon="https://mintcdn.com/duvo-d8027998/O3tlM6eCuFk2uJpN/images/connections/bigquery.svg?fit=max&auto=format&n=O3tlM6eCuFk2uJpN&q=85&s=248c94f17e07206b3f1844ed643d0749" href="/user-guide/connections/available-connections/bigquery" width="24" height="24" data-path="images/connections/bigquery.svg">
    Combine data from multiple warehouse platforms in a single agent to build cross-system reports.
  </Card>
</CardGroup>