# Databricks Warehouse Setup

{% hint style="info" %}
Warehouses are only available for users on the Freshpaint business plan.
{% endhint %}

**1. To get started with warehouse setup, first generate a personal access token. In your Databricks workspace, go to Settings > User Settings > Personal access tokens and click "Generate new token". Once your have your token, record it somewhere.**

**2. Go to Settings > SQL Admin Console > SQL Warehouse settings and add the following Data Access Configuration:**

```
spark.hadoop.fs.s3a.impl shaded.databricks.org.apache.hadoop.fs.s3a.S3AFileSystem
spark.hadoop.fs.s3n.impl shaded.databricks.org.apache.hadoop.fs.s3a.S3AFileSystem
spark.hadoop.fs.s3n.impl.disable.cache true
spark.hadoop.fs.s3.impl.disable.cache true
spark.hadoop.fs.s3a.impl.disable.cache true
spark.hadoop.fs.s3.impl shaded.databricks.org.apache.hadoop.fs.s3a.S3AFileSystem
```

**3. Reach out to <support@freshpaint.io> with the following information about your DB. Besides the access token, you can find the rest of the information by selecting the SQL dropdown option and going to SQL Warehouses > Your Warehouse > Connection Details.**

* access token
  * can be sent securely through [onetimesecret.com](http://onetimesecret.com/)
* server hostname
* port
* http path

**Once this is completed, we'll need to finish the setup on our end. We will notify you once the warehouse is set up.**


---

# Agent Instructions: 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:

```
GET https://documentation.freshpaint.io/integrations/destinations/warehouses/databricks.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
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.