Royal Civic Teal admin experience
Operational control surface
Platform/Admin

Data Mapping Studio

KPI 2026-07-17
Data Intake & Mapping Studio

Guide source data from discovery to approved raw landing.

Source files and streams are profiled, mapped, validated and audited before they can land in raw_upload or raw_airbyte.

Canonical entities
17
Targets available for mapping
Approved profiles
0
0 total profiles
Recent invalid rows
0
No run evidence yet
Refresh required
0
After successful mapped loads
Mapping Editor
5 illustrative fields · no live profile data yet
placeholder
No profile field data returned. Mapping editor showing placeholder rows.
Incoming fieldCanonical fieldSource typeTarget typeRuleRequiredConfidenceApproved
KPI Codetexttextdirect_castyes88%
Reporting Monthdatedatedirect_castyes88%
Actualnumericnumericdirect_castyes88%
Targetnumericnumericdirect_castno88%
Sourcetexttextdirect_castyes88%
Workflow
No source data reaches dashboards directly
Upload CSVSelect target entity and upload source file
Discover fieldsProfile columns and detect types automatically
3Suggest mappingsMap source fields to canonical columns
4Validate previewCatch type errors, nulls and unknown references
5Approve profileSteward sign-off before any data lands
6Load raw landingWrite to raw_upload or raw_airbyte with audit
7Request refreshTrigger dbt run to propagate downstream