Databricks Integration

The Databricks Integration allows your app to connect to Databricks for secure data access, querying, and analytics. Once connected, you can run SQL queries, retrieve results, and power data-driven workflows directly from your app.

With Databricks, your app can:

• Connect securely to your Databricks workspace.
• Run SQL queries or fetch data programmatically.
• Build dashboards and data visualizations on top of your Databricks tables.
• Automate workflows triggered by new or updated data.
• Combine Databricks with AI models for advanced analytics.

1 - Log in to your Databricks Workspace.

2 - Get your DATABRICKS_HOST and DATABRICKS_WAREHOUSE_ID:

• Go to SQL Warehouses from the sidebar.
• Select your desired warehouse.
• Click Connection details.
• Copy the Server hostname (this is your DATABRICKS_HOST).
• Copy the HTTP path removing the /sql/1.0/warehouses/ prefix (this is your DATABRICKS_WAREHOUSE_ID).

3 - Get your DATABRICKS_CATALOG and DATABRICKS_SCHEMA:

• Click the SQL Editor from the sidebar.
• Choose the DATABRICKS_CATALOG and DATABRICKS_SCHEMA from the dropdowns as shown below.

4 - Obtain your authentication credentials:

There are two methods to authenticate your app with Databricks: using a Personal Access Token or via OAuth. Choose one of the methods below to obtain the necessary credentials.

1. In your app, go to Integrations and Add Databricks.
2. Paste your
   1. DATABRICKS_TOKEN
   2. DATABRICKS_HOST
   3. DATABRICKS_WAREHOUSE_ID
   4. DATABRICKS_CATALOG
   5. DATABRICKS_SCHEMA
3. Click Connect to validate and save your integration.

Once connected, the AI Builder can execute queries directly against your Databricks environment.

• Secure your token: Never expose tokens in public code.
• Permissions: Ensure your token or service account has the required workspace and table permissions.
• Combine with AI: Use query outputs to power models, summaries, or alerts in real time.