Managing Data Schemas

This reference article explains how to manage Data Schemas.

Introduction

A Schema Mapping maps source fields to target fields. A Schema Mapping is defined at the Datastream-level. Adverity automatically maps source fields for which you define the default Schema Mapping.

A Data Schema stores information about the list of target fields, the target fields' data types, and the default Schema Mappings for each data source. A Data Schema is defined at the Workspace-level.

This reference article explains how to manage Data Schemas. For more information on configuring Schema Mapping, see Harmonizing data.

Copying Data Schema between Workspaces

To apply a Data Schema in more than one Workspace, copy it between Workspaces.

To copy Data Schema from a source Workspace to a target Workspace, follow these steps:

  1. Export the Data Schema in the source Workspace.

  2. Import the Data Schema in the target Workspace.

Exporting a Data Schema

To export a Data Schema, follow these steps:

  1. Click the Transfer element and select the Workspace you work with in Connect, Enrich & Transfer.

  1. In the left navigation panel, click Data Schema.

  2. In the top right corner of the page, click Schema Actions.

  3. To export to an Excel file, click Export to Excel. To export to a JSON file, click Export to JSON.

  4. Save the file.

Importing a Data Schema

To import a Data Schema from file, follow these steps:

  1. Click the Transfer element and select the Workspace you work with in Connect, Enrich & Transfer.

  1. In the left navigation panel, click Data Schema.

  2. In the top right corner of the page, click Schema Actions.

  3. Click Import from File.

  4. Click Choose File and browse the Schema Mapping file.

  5. Click Upload.

Importing Data Schema from parent Workspace

Child Workspaces do not automatically inherit the Data Schema from their parent Workspaces.

To import a Data Schema in to a child Workspace from its parent Workspace, follow these steps:

  1. Click the Transfer element and select the Workspace you work with in Connect, Enrich & Transfer.

  1. In the left navigation panel, click Data Schema.

  2. In the top right corner of the page, click Schema Actions.

  3. Click Import from Parent Workspace.

  4. Click Yes, I'm sure.

This procedure permanently removes the existing Data Schema. If you have Schema Mappings with target fields that are not present in the imported Data Schema, update those Schema Mappings.