Add Databricks Data Destination to RevSure

Overview

RevSure allows you to connect Databricks as a Data Destination to securely export curated RevSure data into your Databricks environment. Once configured, RevSure can write data directly into your Databricks catalog and schema using a SQL Warehouse, enabling downstream analytics, reporting, and data science workflows.

This integration uses Databricks OAuth (Client ID & Client Secret) for secure authentication and requires appropriate admin permissions in Databricks.

Scribe: Add Databricks Data Destination to RevSure

Step-by-Step: Add Databricks Data Destination

1. Navigate to Data Destination in RevSure

1. Log in to RevSure

2. Go to Data Hub → Data Destination

3. Click Add Data Destination

4. Select Databricks

2. Enter Basic Connection Details

• Provide a Connection Name

• You will be prompted to authenticate with Databricks

3. Verify Databricks User Permissions

In Databricks:

1. Go to Settings

2. Ensure your user is part of the admins group

3. Navigate to:

   • Workspace → Manage account → User management

4. Confirm your user has the Account Admin role

Account Admin access is required to create OAuth app connections.

4. Create an OAuth App Connection in Databricks

1. Go to Settings → App connections

2. Click Add connection

3. Enter:

   • Application Name

   • Redirect URL

     https://gw.revsure-dev.cloud/data-hub/v1/destination/oauth/callback

   • Access Token TTL: 1440 minutes

   • Refresh Token TTL: 129600 minutes

4. Click Add

5. Save the generated Client ID and Client Secret

5. Configure OAuth Details in RevSure

Back in RevSure:

• Enter the saved Client ID

• Enter the Client Secret

• Select the correct Host Type:

  • AWS: *.cloud.databricks.com

  • Azure: *.azuredatabricks.net

  • GCP: *.gcp.databricks.com

6. Configure Catalog and Schema

In Databricks:

1. Go to Profile → Settings → Catalog

2. Copy:

   • Catalog Name (e.g. workspace, system)

   • Schema Name (e.g. default)

In RevSure:

• Enter the Catalog Name

• Enter the Schema Name

7. Configure SQL Warehouse Details

In Databricks:

1. Go to SQL Warehouses

2. Select the target warehouse

3. Copy:

   • Warehouse ID

   • HTTP Path (from Connection details)

In RevSure:

• Enter Warehouse ID

• Enter Warehouse HTTP Path

8. Enter Instance URL

• From your Databricks workspace URL, copy the hostname without https://

Example: dbc-xxxx.cloud.databricks.com

• Paste this into the Instance URL field in RevSure

9. Provide Databricks Account ID

1. Go to: https://accounts.cloud.databricks.com/

2. Copy your Account ID

3. Paste it into the Account ID field in RevSure

10. Connect and Authorize

• Click Connect

• Complete the Databricks OAuth authorization

• Confirm the message “Authorization successful”