02 / Connect
Find the columns that describe the same dimension.
Find the columns that describe the same dimension across datasets.
Example
| Dimension | Source column | Canonical dimension |
|---|---|---|
| Place | STORE_SALES.REGION | Place |
| Place | county_population.county_name | Place |
| Industry | ACCOUNTS.INDUSTRY | Industry |
| Industry | companies.industry_class | Industry |
Use it when systems name columns differently and you need a shared view of what joins with what.
Schemas and distinct values.
CleanDims reads the schemas and distinct values of your sources, never whole rows.
You approve each mapping.
Columns are grouped into dimensions using five signals and one score. A mapping takes effect only when someone approves it. A text join needs the values inside a column to agree, not just the fields.