Relational Based XDM

2 min

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

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.

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.

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
);

echostar-accounts.ddl

Relational Based XDM

Excercise

Upload Your DDL

Entities and Fields to Import

Lab Material

Sample DDL