Schema Mapper

Last updated on May 30, 2023

Hevo ingests your data from Sources, applies Transformations on it, and brings it to Schema Mapper. In Schema Mapper you can define how your data must be stored in the Destination.

You can use Schema Mapper to do the following:

  • Map an incoming Event Type to a Destination table: All the data for that Event Type is stored in the mapped Destination Table.

  • Omit unwanted fields from being stored in the Destination table: This is especially useful to hide sensitive information, such as, your user’s personal details and financial information. You can also omit large text fields like descriptions, summaries, and comments.

  • Flatten nested objects into a de-normalized Destination table: Schema Mapper automatically suggests a de-normalized, flat structure for your incoming nested objects.

  • Compress long names of Events and Event Types: Schema Mapper does this automatically to meaningfully modify the names to fit the character limit set for table and column names in the Destination.

In addition, Schema Mapper provides you the Auto Mapping feature, which:

  • Automatically creates and manages all the mappings for you.

  • Creates tables with compatible and optimal data types in your Destination warehouse, if none exist.

  • Marks incompatible incoming Events as Failed for investigation.

In this Section

The following interactive diagram illustrates the features and actions offered by the Schema Mapper and provides a summary view of the section’s content. Click on any item in the diagram to view the related information.

Skip Events Reset schema Enable Auto Mapping View activity log Fix unmapped fields Map for a new Pipeline Map to a new table Change Destination table Change Destination column Enable & disable Auto Mapping Mapping statuses Limits in Destination columns Compatibility table Fix unmapped fields Resolve incompatible mappings Manual Schema Mapping Schema Mapper Actions References Resolving Incompatibilities Access Schema Mapper Auto Schema Generation Schema Mapper

Revision History

Refer to the following table for the list of key updates made to this page:

Date Release Description of Change
May-30-2023 NA Added the Schema Mapper interactive infographic.

Tell us what went wrong