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

# Databricks Setup and Configuration

> Set up Databricks as an Inflection data source and export destination.

## Export Inflection Data to Databricks

For information on tables and schemas that inflection exports to Databricks, please read this

<AccordionGroup>
  <Accordion title="Set up Export to Databricks in Inflection">
    These steps need to be run by someone with access to

    1. Go to **Connections → Data Connections**, then click **Add new connection**.

           <img src="https://mintcdn.com/inflection-4b2c0de4/N4VRWuxaoalXbMy_/images/connections/warehouses/databricks/01.png?fit=max&auto=format&n=N4VRWuxaoalXbMy_&q=85&s=1c4f4ab191002b648ef285b678e6056c" alt="Add new connection button on the Data Connections page" width="3840" height="1868" data-path="images/connections/warehouses/databricks/01.png" />

    2. **Choose your platform**: Select **Databricks** as your destination platform.

    3. **Select connection type**: Choose **Export Data to Databricks**.

           <img src="https://mintcdn.com/inflection-4b2c0de4/N4VRWuxaoalXbMy_/images/connections/warehouses/databricks/02.png?fit=max&auto=format&n=N4VRWuxaoalXbMy_&q=85&s=799fecd9f51497c7010766adeb4a5970" alt="Choosing Databricks as the platform and Export Data to Databricks as the connection type" width="512" height="480" data-path="images/connections/warehouses/databricks/02.png" />

    4. **Enter your DW credentials**

       Give a name for your data warehouse connection and fill in your credentials.

       * For **Databricks**: Enter client ID, client secret, host, catalog, schema and HTTP path.

    <Warning>
      Make sure the service principal used for Inflection access has at least the following minimum permissions on the target catalog for data export.

      <img src="https://mintcdn.com/inflection-4b2c0de4/N4VRWuxaoalXbMy_/images/connections/warehouses/databricks/03.png?fit=max&auto=format&n=N4VRWuxaoalXbMy_&q=85&s=bdc501ed2291ed42601db570e5ec45bb" alt="Minimum permissions required on the target catalog for the Inflection service principal" width="1764" height="1631" data-path="images/connections/warehouses/databricks/03.png" />
    </Warning>

    2. Click **Create Connection** to set up the connection. Note that syncing will NOT BEGIN and connection will be in INACTIVE state until the credentials and destination tables are validated by your Inflection team.
  </Accordion>

  <Accordion title="Set up Databricks to accept Inflection Data">
    We provide a custom SQL script tailored to your configuration. You'll need to run this script to create the export tables in your DW.

    <img src="https://mintcdn.com/inflection-4b2c0de4/N4VRWuxaoalXbMy_/images/connections/warehouses/databricks/04.png?fit=max&auto=format&n=N4VRWuxaoalXbMy_&q=85&s=42638730c7a3b7bb9858ff1a9ea8f37f" alt="Sample SQL. Do not use this directly. Please refer to the SQL shown on inflection UI for your connection" width="2000" height="602" data-path="images/connections/warehouses/databricks/04.png" />

    The script creates tables with the necessary structure and permissions (INSERT, UPDATE, DELETE) for Inflection to write data.
  </Accordion>

  <Accordion title="Submit Setup for Activation">
    Once your credentials are saved and your data team has created the required tables in your warehouse, your setup is complete.

    At this point:

    * Inflection's team will validate the setup and activate the sync for you.
    * No additional steps are required from your side.
      * Optionally, you may test or delete the connection at this stage
    * You will be notified once the sync has started and data is being sent.

    <Info>
      Activation may take up to two business days. Please ensure your data team notifies you once your tables are set up in your data warehouse.
    </Info>
  </Accordion>
</AccordionGroup>

And that's it! Once you are set up, you can monitor sync health by following our guide here.

## Import Databricks Data to Inflection

Inflection can read data directly from your Databricks workspace using **Databricks-to-Databricks Delta Sharing**. You stay fully in control of what's shared; Inflection only receives read-only access to the specific tables you choose.

This instructions below walk you through:

1. Setting up a **Delta Sharing share** in your Databricks Unity Catalog.
2. Granting Inflection access using our **metastore identifier**.
3. Configuring the **Databricks connection** inside Inflection.

<AccordionGroup>
  <Accordion title="Pre-requisites">
    To complete this setup, you'll need:

    * A **Unity Catalog–enabled** Databricks workspace.
    * Permissions to:
      * Create and manage **shares** and **recipients** in Unity Catalog.
      * Grant `SELECT` access on the tables/schemas you want to share.
    * The Inflection **Databricks metastore identifier**:

      ```text theme={null}
      aws:us-west-2:7bd7c54d-5bf4-41c6-b6c8-752437ed524d
      ```
  </Accordion>

  <Accordion title="Part 1: Configure Databricks">
    ### Step 1: Choose what to share

    Decide which objects Inflection should have access to:

    * One or more **tables**, for example:
      * `your_catalog.your_schema.product_activity`
      * `your_catalog.your_schema.contacts`
    * Or an entire **schema** in a catalog (e.g. `your_catalog.your_schema`).

    You can add or remove objects from the share later; no need to get it perfect on day one.

    ### Step 2: Create a Share in Unity Catalog

    You can create the share using the **Catalog Explorer**.

    1. In Databricks, open the **Catalog** panel.

    2. Click the **gear icon (⚙)** and choose **Delta Sharing**.

    3. Under **Shared by me**, click **Create share** / **Share data**.

    4. Enter a **Share name**, for example:

       ```text theme={null}
       inflection_share
       ```

    5. Click **Save and continue**.

    6. On the next step, add the tables/schemas you want to share to Inflection, then save.

    You'll use this exact **Share name** again when you configure the connection in Inflection.

    ### Step 3: Create a Databricks Recipient for Inflection

    Next, create a **recipient** that represents Inflection's Unity Catalog metastore, using the identifier we provided.

    1. In Databricks, go to **Catalog → ⚙ Delta Sharing**.

    2. Go to the **Shared by me** tab.

    3. Click **New recipient**.

    4. Choose a **Recipient name**, for example:

       ```text theme={null}
       inflection_recipient
       ```

    5. For **Recipient type**, select **Databricks**.

    6. In the **Databricks metastore identifier** field, paste:

       ```text theme={null}
       aws:us-west-2:7bd7c54d-5bf4-41c6-b6c8-752437ed524d
       ```

    7. Save the recipient.

    ### Step 4: Grant the Share to Inflection

    Finally, grant the share to the recipient you just created.

    1. In **Catalog → ⚙ Delta Sharing → Shared by me**, click your share (`inflection_share`).
    2. Open the **Recipients** tab.
    3. Add `inflection_recipient` and grant it access.
  </Accordion>

  <Accordion title="Part 2: Configure the Connection in Inflection">
    ### Step 5: Open the Databricks Connector in Inflection

    1. Log in to your Inflection workspace.
    2. Navigate to **Connections → Data Connections**.
    3. Click **+** / **Add connection** to open the **Connection Marketplace**.
    4. Under **Data Warehouse**, choose **Databricks**.

           <img src="https://mintcdn.com/inflection-4b2c0de4/N4VRWuxaoalXbMy_/images/connections/warehouses/databricks/05.png?fit=max&auto=format&n=N4VRWuxaoalXbMy_&q=85&s=60288ba6b8009675028828981c868f9a" alt="Databricks tile under Data Warehouse in the Connection Marketplace" width="2880" height="1626" data-path="images/connections/warehouses/databricks/05.png" />

    ### Step 6: Choose sync type

    On the **"Setting up Databricks connection"** screen:

    1. Select **Read Databricks Data**
    2. Click **Enter connection details**.

           <img src="https://mintcdn.com/inflection-4b2c0de4/N4VRWuxaoalXbMy_/images/connections/warehouses/databricks/06.png?fit=max&auto=format&n=N4VRWuxaoalXbMy_&q=85&s=a31f2c5ad2c8169039409437dee198c4" alt="Read Databricks Data option on the Setting up Databricks connection screen" width="1024" height="986" data-path="images/connections/warehouses/databricks/06.png" />

           <img src="https://mintcdn.com/inflection-4b2c0de4/N4VRWuxaoalXbMy_/images/connections/warehouses/databricks/07.png?fit=max&auto=format&n=N4VRWuxaoalXbMy_&q=85&s=d1355bd8f41207b89db2d16aaf7dc6a1" alt="Databricks connection details form" width="1024" height="1048" data-path="images/connections/warehouses/databricks/07.png" />

    ### Step 7: Mapping DW to Inflection Objects

    Use the document below to Map Inflection Tables to Databricks:

    the related Help Center article
  </Accordion>
</AccordionGroup>

And that's it! Once you save the mapping and you connection is active, you can monitor the sync health. If you encounter any issues, reach out to the Inflection team.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.