Default Data Mapping

This guide provides an overview of Adverity's Default Data Mapping and how to apply it to your datastreams.

Introduction

Default Data Mapping automatically maps source fields to target fields. Adverity provides Default Data Mapping for the most commonly used source fields for a number of connectors. You can configure Default Data Mapping for any source field that you have fetched in Adverity.

This saves you time when creating new datastreams and ensures that all datastreams that fetch data from the same data source use the same Data Mapping.

Viewing your Default Data Mapping

To view your Default Data Mapping, follow these steps:

  1. Go to the Data Dictionary page.

  2. Under the page heading, click Default Data Mapping.

In this example, Default Data Mapping has been defined for all target fields for Google Sheets datastreams. For example, Adverity will automatically map the Released source field to the year_released target field in all future Google Sheets datastreams.

Default Data Mapping has not been defined for any of the visible target fields for Wikipedia datastreams.

  1. Use these filters and the search function to view specific target fields. All displays all target fields, Used displays all target fields that are used in your current Workspace, and Unused displays all target fields that are not used in your current Workspace. You can also use the search bar to search for target fields by the name in the Target field column.

  2. Click here to export your Default Data Mapping or change the page view.

  3. Click here to configure Adverity's Default Data Mapping for a field. For detailed instructions, see Configuring your Default Data Mapping.

Configuring your Default Data Mapping

After you have successfully created a datastream and fetched data from a data source in Adverity, a column named after the data source will appear in the Default Data Mapping. This column contains the source fields you have fetched from this data source.

To configure Default Data Mapping for this data source, follow these steps:

  1. Go to the Data Dictionary page.

  2. Under the page heading, click Default Data Mapping.

  3. In your chosen data source's column and in the row containing the target field for which you want to define Default Data Mapping, click Select.....

  4. In the drop-down menu, select the source field that you want Adverity to automatically map to this target field in future.

As a result, you have successfully mapped your selected source field to the target field in this row.

For example, if you select the source field views in the column for Wikipedia and the row containing the full_views target field, Adverity will automatically map views to full_views in all future Wikipedia datastreams that contain this source field.

Applying Adverity's Default Data Mapping to a datastream

Adverity's Default Data Mapping maps source fields to target fields in a way that works for most Adverity users. Using the Default Data Mapping, you do not need to map source fields to target fields manually.

To apply Adverity's Default Data Mapping to a datastream, follow these steps:

  1. Go to the Datastreams page.

  2. Select the datastream to which you want to apply the Default Data Mapping.

  3. In the top navigation panel, click Data Mapping.

  4. Click Restore defaults.

The Data Mapping changes are saved automatically.

As a result, any changes you have made in the Data Mapping tab will be replaced with Adverity's Default Data Mapping.