Documentation Experience Platform Federated Audience Composition

Schemas overview schemas

Last update: October 6, 2026

AVAILABILITY

The new schemas experience is only available to select customers. For more information, contact Adobe Customer Care.

If you don’t have access to the new schemas experience, read the schemas overview.

To access schemas, you’ll need one of the following permissions:

-Manage Federated Schema
-View Federated Schema

For more information on the required permissions, please read the access control guide.

A schema is a representation of a table of your database. It is an object within the application that defines how the data are tied to database tables.

By creating a schema, you can define a representation of your table in Experience Platform Federated Audience Composition:

Give it a friendly name and description to simplify the comprehension for the user
Decide the visibility of each field, according to their real use
Select its primary key, in order to link schemas between them, as needed in the data model

CAUTION

When connecting multiple sandboxes with the same database, you must use distinct working schemas.

Create a schema create

To create a schema in Federated Audience Composition, select Schemas within the Data Management section of the Experience Platform UI. Within the Schemas UI, select Create schema.

The Schemas and the Create schema buttons are both highlighted within the Schemas UI.

Once the Create schema popover appears, select Relational, followed by Discover schemas and Next to create a schema for Federated Audience Composition.

The Discover schemas button is highlighted within the Create a relational schema popover.

The Select federated database popover appears. On this popover, you can select the source database, followed by Next.

The Select federated database popover is displayed.

Define schema define

After choosing the federated database, you can now define your schema. The Add data screen appears. On this page, you can select Add table to choose which tables you want to add to the schema.

The Add table button is highlighted within the Add data screen.

The Select Table popover appears. On this popover, you can select the tables which you want to use to create the schema.

The Select Table popover is displayed. {modal="regular"}

Each selected table generates a schema with the chosen columns. For each table, you can change the label of the schema, add a description, rename the field label, set the field label visibility, and select the schema primary key.

The selected tables are displayed within the Add data page. {modal="regular"}

NOTE

If you choose Composite Key but only select one key to be used, the key will be treated like a standard schema primary key.

Additionally, you can create a key that is made up of multiple schema columns. Select Composite Key, and mark the keys you want to use as your composite key.

Both the Composite Key toggle and the schemas are selected. {modal="regular"}

After completing your configuration, select Done to finish creating your schema.

Edit a schema schema-edit

To edit a schema, select the next to your previously created schema on the Schemas page, followed by Edit.

The Edit schema button is highlighted.

On the Edit schema window, you can see the Schema Editor. For more information on using the Schema Editor, read the schema UI guide.

The Schema Editor is displayed.

Edit relationships relationship-edit

To edit the relationships for a schema, select View entity diagram within the Schema Editor.

The View entity diagram button is highlighted.

The entity diagram page appears. On this page, you can create links to establish relationships between your schemas.

The entity diagram is displayed.

For more information on creating links, read the Canvas view tab of the data models overview.

Preview data in a schema schema-preview

To preview the data in the table represented by your schema, go to the Datasets section, and then select Browse.

The Datasets and the Browse buttons are highlighted.

Select the , followed by Preview dataset to see a preview of the data within the schema.

The Preview dataset button is highlighted.

Refresh a schema schema-refresh

Tables in a federated database can be updated, added or removed. In such cases, you must refresh the schema in Adobe Experience Platform to align with the latest changes. To refresh the schema, select the More button, followed by Manage configuration.

The Manage configuration button is highlighted.