Get started with schemas schemas

What is a schema schema-start

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:

Create a schema schema-create

To create a schema in Federated Audience Composition, select Models in the Federated Data section. Within the Schema tab, select Create schema.

{modal="regular"}

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

{modal="regular"}

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

{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.

{modal="regular"}

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

{modal="regular"}

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

Edit a schema schema-edit

To edit a schema, select your previously created schema on the Schemas page.

The schema details page appears. Select the to edit the schema.

{modal="regular"}

On the Edit schema window, you can access and configure the same options as when creating a schema.

{modal="regular"}

Preview data in a schema schema-preview

To preview the data in the table represented by your schema, browse to the Data tab as below.

Select Calculate link to preview the total number of recordings.

{modal="regular"}

Select the Configure columns button to change the data display.

{modal="regular"}

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 perform this, select the next to the name of the schema followed by Refresh schema.

You can also update the schema definition when editing it.

{modal="regular"}

Delete a schema schema-delete

To delete a schema, select the , followed by Delete.

{modal="regular"}