> ## Documentation Index
> Fetch the complete documentation index at: https://docs.stigg.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Databricks

## Overview

Stigg's integration with Databricks allows you to export your product catalog, customer, and subscription data directly to a Databricks SQL warehouse for analytics and data engineering workflows.

<Note>
  Stigg's native data export integrations are included in the Scale plan, and are also available as an optional add-on to the Growth plan. See Stigg's pricing for more details.
</Note>

## Exported entities

When connecting Databricks, you can choose which Stigg entity groups to include in the sync. All groups are selected by default.

See [Exported entities](./overview#exported-entities) for the full list of entity groups and the tables within each.

<Card title="Entity schema" icon="sitemap" href="./schema" horizontal />

## Setting up the integration

### Prerequisites

* A Databricks workspace with a SQL warehouse
* A service principal (recommended) or personal access token with permission to read/write the target catalog and schema

<Steps>
  <Step title="Create a service principal (recommended)">
    In your Databricks workspace, create a [service principal](https://docs.databricks.com/en/administration-guide/users-groups/service-principals.html) and generate an OAuth client ID and secret. Grant the service principal `USE CATALOG`, `USE SCHEMA`, `CREATE TABLE`, and `MODIFY` privileges on your target catalog and schema.

    Using a service principal with OAuth is recommended over a personal access token, as it provides short-lived credentials and better security controls.
  </Step>

  <Step title="Connect Stigg with Databricks">
    In [Stigg](https://app.stigg.io/), navigate to **Integrations > Apps > Databricks**.

    Enter the following information in the connection form:

    | Field             | Description                                                                                      |
    | ----------------- | ------------------------------------------------------------------------------------------------ |
    | Server hostname   | The SQL warehouse hostname from the **Connection Details** tab in your Databricks workspace      |
    | Port              | The port for the SQL warehouse connection, from the **Connection Details** tab. Typically `443`. |
    | HTTP path         | The HTTP path from the **Connection Details** tab                                                |
    | Catalog           | The target Unity Catalog name                                                                    |
    | Schema            | The schema where Stigg will create and sync tables                                               |
    | Auth method       | **OAuth (service principal)** (recommended) or **Personal access token**                         |
    | Client ID / Token | The OAuth client ID or personal access token                                                     |
    | Client secret     | The OAuth client secret (OAuth only)                                                             |

    Click **Test & connect**.
  </Step>

  <Step title="Select entities to export">
    After entering your connection details, expand the **Entities to export** section to choose which entity groups to include in the sync. All groups are selected by default.

    See [Exported entities](./overview#exported-entities) for a description of each group.
  </Step>
</Steps>

## Sync process and schedule

After setup, Stigg performs a full sync of all selected entities. Subsequent syncs are incremental, transferring only changes since the last run.

Stigg syncs data on a configurable schedule — daily at 12:00 AM UTC by default. You can adjust the sync frequency from the integration settings at any time.

## Manual sync

To trigger an immediate sync, open the Databricks integration in [Stigg](https://app.stigg.io/) and click **Sync now**.

## Sync history

The integration page shows a log of all past and in-progress syncs. The dashboard updates automatically as syncs complete.

Each row shows the sync status and timestamps. Expand a row to see rows synced per entity, sync duration, trigger source, and who initiated it.

Use the status and date filters to find a specific sync run.

## Removing the integration

To remove the integration, click on the dotted menu icon and select the **Remove** action.

Confirm the action by clicking on the **Remove** button in the opened modal.