Get started with Relational Schemas and Datasets gs-schemas

This guide walks you through the process of creating a relational schema, configuring a dataset for Orchestrated campaigns and ingesting data.

A dataset is a storage and management construct for a collection of data, typically a table, that contains a schema (columns) and fields (rows). Data that is successfully ingested into Experience Platform is stored within the data lake as datasets.

A schema represents and validates the structure and format of data. It provides an abstract definition of a real-world object (such as a person) and outlines what data should be included in each instance of that object (such as name, birthday, and so on).

  1. Create relational schema manually or using a DDL file

    Define the structure of your data model, including tables, attributes, and relationships. Choose to build the schema manually in the user interface or upload a DDL file for faster setup.

    When creating the schema manually, dataset must also be created and enabled manually. Wehn using a DDL file, dataset creation and enablement are automatic.

  2. Link schema

    Establish relationships between your schemas to ensure data consistency and enable cross-entity queries. For example, link loyalty transactions to recipients or rewards to brands.

  3. Ingest Data

    Bring data into Adobe Experience Platform from supported sources such as SFTP, cloud storage, or databases.

recommendation-more-help
b22c9c5d-9208-48f4-b874-1cefb8df4d76