Databricks (Delta Sharing) - Dema.ai documentation

Supported data types

Inventory

Stock levels

Logistics

Shipping & fulfillment costs

Orders

Customer transactions

Product Attributes

Product metadata & descriptions

Prerequisites

Before setting up the Databricks integration, ensure you have:

A Databricks workspace with Delta Sharing enabled
Tables in Unity Catalog containing your data, with columns matching our schema
A share containing the relevant tables that can be shared externally

Good to know

COGS priority

Storefront assignment

If you operate multiple storefronts, include EXTERNAL_STOREFRONT_ID in your data for per-row storefront assignment.

Merchant mappings

Step-by-step integration guide

Create a Delta Share

In your Databricks workspace, create a Delta Share containing the tables you want to integrate. Ensure the tables have columns matching our schema below.Refer to the Databricks Delta Sharing documentation for details on creating and managing shares.

Share credentials

Provide the following to your Customer Success Manager:

Send the information via secure password sharing.

Delta Sharing credentials:

Credentials

{
  "bearerToken": "<your-token>",
  "endpoint": "https://<workspace-url>/api/2.0/delta-sharing",

  // optional
  "icebergEndpoint": "https://<workspace-url>/api/2.0/unity-catalog/iceberg",
  "expirationTime": "2026-12-31T23:59:59.999Z"
}

Table configuration:

Connection

{
  "shareName": "example_share",
  "schema": "example_schema",
  "table": "example_table"
}

Specifying data tables and schema

Ensure each table aligns with our schema. Columns must be named according to the column names specified in the schema below. This is crucial for accurate data integration.

Finalizing integration

After setting up the share and ensuring data mapping accuracy, our team will finalize the integration process, enabling data flow from Databricks into our platform.

Multiple values Some fields allow multiple values. These fields can be added as column of Array type, like ["value1", "value2", "value3"].

Data schema

Inventory

Version 2 (Current)
Version 1 (Legacy)

The current inventory format — only the stock-level and cost fields.

Fields

required

Logistics

Shipping and fulfillment costs associated with orders.

The system supports both outbound shipments to customers and return shipments from customers.

Fields

Orders

Customer transaction data including order details and line items. See COGS priority for how cost values are resolved.

How order data should be structured

Each row represents a unique order line, identified by the combination of ORDER_ID, PRODUCT_ID, and VARIANT_NO.

Requirement	Description
Unique rows	Each row must have a unique `ORDER_ID-PRODUCT_ID-VARIANT_NO` combination
Quantity handling	If multiple items of the same variant were bought, aggregate them using `QUANTITY`
Tax inclusion	All prices should include tax
Header repetition	Order header fields (like `ORDER_ID`, `CURRENCY`, `TOTAL`) must be repeated for every line item in the same order
Updates	When an order changes, update the existing rows for that `ORDER_ID` in place and set `UPDATED_AT` to the current timestamp. Do not insert duplicate rows — each `ORDER_ID`–`PRODUCT_ID`–`VARIANT_NO` combination must remain unique
Line-level overrides	Line-level fields override their order-level equivalents when set: `STATUS_LINE` overrides `STATUS`, and `SHIPPING_PROVIDER_LINE` overrides `SHIPPING_PROVIDER`
Storefront mapping	To map data to a specific storefront, fill out `EXTERNAL_STOREFRONT_ID` and provide us with info about your existing storefronts, see Storefront assignment

Order header fields

Required:

Order line fields

Required:

Return fields (within orders)

Include these fields to record returns directly in your orders table.Required:Optional:

Custom attributes

Order header level:Order line level:

Product Attributes

Product metadata including names, categories, and descriptive attributes for your catalog.

Required fields

Optional fields

Custom attributes

Troubleshooting and support

For common issues and solutions, contact our support team directly for assistance.

Additional resources

Databricks Delta Sharing documentation: Databricks Documentation

​Supported data types

Inventory

Logistics

Orders

Product Attributes

​Prerequisites

​Good to know

​Merchant mappings

​Step-by-step integration guide

​Data schema

​Inventory

​Logistics

​Orders

​Product Attributes

​Troubleshooting and support

​Additional resources

Supported data types

Prerequisites

Good to know

Merchant mappings

Step-by-step integration guide

Data schema

Inventory

Logistics

Orders

Product Attributes

Troubleshooting and support

Additional resources