Arcwise Documentation
English
English
  • πŸ‘‹Welcome to Arcwise!
  • πŸ“˜Arcwise setup
    • βš™οΈUser & Role Management
    • 🌐Add to Google Workspace
    • πŸ”ŒConnect Data Warehouse
      • πŸ“«Arcwise Fixed IP Address
      • ❄️Snowflake
      • πŸ”BigQuery
      • 🐘Postgres
      • 🧱Databricks
      • πŸͺΆAthena
      • πŸͺ£S3
    • πŸ’»Connecting data tools
      • πŸŽ†Connect to dbt
      • πŸ”ŽConnect to Looker
      • 🧊Connect to Cube
    • πŸ“œAudit logging
    • ☁️Integrations
      • Overview
      • Hubspot
      • Salesforce
    • ❔FAQ
  • πŸ”Google Login Errors
  • πŸ“œProduct Changelog
  • Connecting data
    • ✨Connecting Data
    • πŸ’ΏData Warehouse
    • ⬆️Uploading CSV Files
    • πŸ”¨Importing Data from Other Tools
    • πŸ€–Selecting Spreadsheet Data for AI Analysis
  • Using Arcwise in sheets
    • ▢️Arcwise Connected Data
      • Adding Columns
      • Filtering
      • Sorting
    • πŸ—ƒοΈWorking With Large Data
    • πŸ§ͺUsing Formulas in Sheets
    • 🟰Supported Formulas
    • πŸ“ŠPivot Tables
    • πŸ“‰Creating Manual Visualizations
  • Using Arcwise AI Analyst
    • πŸ€–AI Analyst Overview
    • ❇️Using AI Analyst in Sheets
    • πŸ“‚Getting Data Using AI
    • πŸ“ˆCreating a Visual
    • πŸ’‘Generating an Insight
    • πŸ“ƒUsing AI Analyst on Spreadsheet Data
    • Embedding the AI Analyst Chat
  • Using Arcwise AI Formulas
    • πŸ€–GPT Formulas Overview
    • βœ”οΈGPT Formula Basics
    • πŸ“–GPT Formula Reference
Powered by GitBook
On this page
  • (Optional) Allow connection from Arcwise IP address
  • Add Databricks credentials in Arcwise
  • Information about required fields
  • Checking indexed tables/views
  • (Optional) Connecting to dbt
  1. Arcwise setup
  2. Connect Data Warehouse

Databricks

PreviousPostgresNextAthena

Last updated 1 year ago

(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 page.

Add Databricks credentials in Arcwise

  1. Log into the Arcwise Admin portal and .

  2. Go to the β€œConnections” tab in the Arcwise admin panel ()

  3. Click on the β€œ+ Create” button (top-right) and select "Databricks" from the Warehouse Type dropdown.

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

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

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

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.

Personal Access Token - must be an access token with permissions to use the warehouse/cluster provided above. See the docs for the required permissions:

Go to the 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 .

πŸ“˜
πŸ”Œ
🧱
https://docs.databricks.com/integrations/jdbc-odbc-bi.html#retrieve-the-connection-details
https://docs.databricks.com/integrations/jdbc-odbc-bi.html#permission-requirements
Tables page
Connections page
set up users/roles for your team first
https://admin.arcwise.app/#/warehouse_connections
(You should see these fields for Databricks connections).