> For the complete documentation index, see [llms.txt](https://docs.sortment.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.sortment.com/setup/data-warehouses/databricks.md).

# Databricks

## Overview

Sortment lets you pull data stored in your Databricks warehouse and use it to create schema.

## Configuring Databricks in Sortment

The credentials needed to connect to your cluster can be found in the ODBC options in your databricks account. Enter the following required fields into Sortment:

1. **Server hostname**: To find your server hostname, visit the Databricks web console and locate your cluster. Then, click to reveal Advanced options and navigate to the JDBC/ ODBC tab.
2. **HTTP path**: To find your HTTP path, visit the Databricks web console and locate your cluster. Then, click to reveal Advanced options and navigate to the JDBC/ ODBC tab.
3. **Personal Access Token:** To get your personal access token from user settings in Databricks, open **Settings** by clicking the cog ⚙️ in the sidebar and select **User settings.** Click **Generate token**. You'll be asked to enter a name and expiry. Copy the token and put it in Sortment.
4. **Catalog name**: Catalog shared here will be used by Sortment to publish audiences and campaigns data back into your Databricks account.
5. **Database:** The tables shared in the database will be available to be used in Sortment.

## Test your connection <a href="#test-your-connection" id="test-your-connection"></a>

When setting up a source for the first time, Sortment validates the following:

* Network connectivity
* Databricks credentials
* Permission to list schemas and tables
* Permission to write to the catalog

Some sources may initially fail connection tests due to timeouts. Once a connection is established, subsequent API requests should happen more quickly, so it's best to retry tests if they first fail. You can do this by clicking **Test again**.

## Blob setup for Databricks

Once you've saved these Databricks credentials, you're ready to set up the blob credentials in Sortment. Blob storage helps to move data out from your warehouse to messaging provider. This is also used to batch events coming from campaigns before they are sent back into your warehouse for analytics.

In case your Databricks account is hosted in AWS, use [Amazon S3 setup](/setup/cloud-bucket-storage/amazon-s3-for-snowflake.md) to set up the blob storage.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.sortment.com/setup/data-warehouses/databricks.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.