---
title: Relational Based XDM
slug: echostar-b2b-poc/relational-based-xdm
docTags: 
createdAt: 2025-10-15T21:01:49.087Z
---

![](https://experienceleague.adobe.com/en/docs/journey-optimizer/using/campaigns/orchestrated-campaigns/data-configuration/schemas-datasets/media_1ac0bceb690e93404e27f371fe3ea1060cc2e662f.png?width=2000\&format=webply\&optimize=medium)

:::ExpandableHeading{isOpen="true"}
## Excercise

### Upload Your DDL

- Under **Data Management**, click **Schemas**.
- Click **Create Schema**
- Select the option **Relational Schema**
- Select the option **Upload DDL File**
- Drag and Drop your DDL File, Click **Next**

![](https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/bsoY-lONjbbjvKUlukHkQ-20260116-150008.png)

### Entities and Fields to Import

We created a flat table with a Primary Key without relatable entities or identity namespaces, we will connect this data to a profile during our workflow. However, we must do a few things here:

- Add your initials to the name of each datasets so every participant has a different table of their own. "table\_name\_**INITIALS**"
- Select the **version\_control**  as the version column. 
- Set the **Primary Key** for each schema.
- Click Done.

![](https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/eqSRTtkLRxJ_5V-LefpYK_screenshot-2026-09-09-at-112849-pm.png)
:::

:::ExpandableHeading{isOpen="true"}
## Lab Material

### Sample DDL

You can either download the file or copy the contents and save it in a note pad (notepad++, notes, textEdit, etc) with the extension **.ddl**.

```sql
CREATE TABLE account_billing (
    id                   VARCHAR(20) PRIMARY KEY,
    account_number       VARCHAR(20) NOT NULL,   -- identifier, NOT a number
    auto_pay_indicator   BOOLEAN,
    payment_dttm         TIMESTAMP,
    payment_channel      VARCHAR(32),
    next_billing_date    DATE,
    payment_method       VARCHAR(32),
    version_control      TIMESTAMP
);

CREATE TABLE account_billing_address (
    id                   VARCHAR(20) PRIMARY KEY,
    account_number          VARCHAR(20) PRIMARY KEY,   -- identifier, NOT a number
    billing_address_line_1  VARCHAR(255),
    billing_address_line_2  VARCHAR(255),
    billing_city_name       VARCHAR(128),
    billing_postal_code     VARCHAR(10),
    billing_state_code      VARCHAR(2),
    version_control         TIMESTAMP
);

```
:::

::File{src="https://api.archbee.com/api/presign/1Jp0iolWv35Z_mkI7oUiT/muKdix5u0PUlnNT6gURwy_echostar-accounts.ddl" label="echostar-accounts.ddl"}