Semantic layer & auto-mapping
Auto‑mapping uses heuristics and metadata to infer relationships among tables and columns.
It analyzes foreign keys, naming conventions and data types to propose a semantic model with entities, attributes and joins. Users can then review and refine the mappings.
Auto‑mapping reduces the time required to expose data in a business‑friendly format—a key differentiator when deadlines are tight.
It also kick‑starts the intent‑to‑SQL flywheel: once the system understands your schema, it can generate natural language answers.
MageMetrics employs machine learning to map schemas in minutes and suggests dimensions and metrics based on usage patterns.