This article explains how the Data Mapper (Data Mapping Manager) data app works and how to use it to enrich an existing data warehouse table with custom “mapping” columns.

Overview

The Data Mapper helps you create a mapping/enrichment table on top of an existing source table.

Typical use cases

• Add a category, region, owner, status, or any other business label to existing rows.
• Maintain a manual mapping table that can be joined back to the source table using a primary key.

Core idea

• Source columns are read-only.
• Mapping columns are editable.
• When you click Save, the app writes everything to a destination table (it does not modify the source table).

How it works (high level)

1. Select a source table (warehouse → schema → table)
2. Choose source columns to display
3. Pick a primary key and define a destination table
4. Add mapping columns
5. Fill values (inline editor) or upload a file
6. Save to the data warehouse
7. (Optional) Save a configuration so you can reload everything later