# Databricks

## (Optional) Allow connection from Arcwise IP address

If you need to add a fixed IP address to your allowlist or network policy, please refer to our  [Arcwise Fixed IP Address](/arcwise-setup/connect-data-warehouse/arcwise-fixed-ip-address.md) page.

## Add Databricks credentials in Arcwise

1. Log into the Arcwise Admin portal and [set up users/roles for your team first](/arcwise-setup/user-and-role-management.md).
2. Go to the “Connections” tab in the Arcwise admin panel (<https://admin.arcwise.app/#/warehouse_connections>)
3. Click on the “+ Create” button (top-right) and select "Databricks" from the Warehouse Type dropdown.

<figure><img src="/files/HeXq151mWsQDRAY0v5D0" alt="" width="563"><figcaption><p>(You should see these fields for Databricks connections).</p></figcaption></figure>

### Information about required fields

1. **Name** - A user-friendly name used for display purposes in the Arcwise interface. Can be anything you want.
2. **Server Hostname / HTTP Path**
   1. Follow the Databricks documentation on finding these fields - for compute clusters, this will be on the **Advanced Options > JDBC/ODBC** settings page, and for SQL warehouses this will be under **Connection Details**. <https://docs.databricks.com/integrations/jdbc-odbc-bi.html#retrieve-the-connection-details>&#x20;
3. **Personal Access Token** - must be an access token with permissions to use the warehouse/cluster provided above. See the docs for the required permissions: <https://docs.databricks.com/integrations/jdbc-odbc-bi.html#permission-requirements>
   1. *Arcwise only requires read permissions. We recommend that you ensure the PAT has finer-grained permissions for safety purposes; Arcwise users can execute SELECT SQL queries to access any schemas and tables that the PAT has (read) access to.*
4. **Catalog** - The top-level catalog (as shown in Databricks' Data Explorer) that you would like Arcwise to access. **If you're not using Unity Catalog, this must be `hive_metastore`.**

### **Checking indexed tables/views**

Arcwise will automatically index your data catalog upon the initial connection; our index will also automatically refresh every day at midnight PST.

Go to the [Tables page](https://admin.arcwise.app/#/warehouse_entities) in the Arcwise panel to see the list of indexed tables / views.

To manually re-index tables, you can press the "Sync" button back on the [Connections page](https://admin.arcwise.app/#/warehouse_connections).

### (Optional) Connecting to dbt

Arcwise supports indexing your dbt catalog to surface metrics and models in the UI. If you'd like us to do this, proceed to the next step to connect your dbt credentials.


---

# 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://docs.arcwise.app/arcwise-setup/connect-data-warehouse/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.