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).
-
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.
-
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.
-
Bring data into Adobe Experience Platform from supported sources such as SFTP, cloud storage, or databases.