--- title: "Data Mart Management — Define Once, Reuse Everywhere | OWOX" canonical: "https://www.owox.com/features/data-mart-management" updated: "2026-09-17" --- Data Mart Management # Define the logic once. Reuse it everywhere. A Data Mart is analyst-defined logic — SQL, Table, View, Pattern, Connector or Joinable — published once and reused by every report in Google Sheets, Excel, Looker Studio, Slack, Teams, email and your AI assistant. Nothing reaches a destination until the analyst publishes it. [Get started free](https://www.owox.com/app-signup?utm_source=owox.com&utm_medium=website&utm_campaign=features&utm_content=hero) [Read the docs →](https://docs.owox.com/docs/getting-started/core-concepts/#data-mart) ![Data Mart Management](/images/features/data-mart-management/hero.png) ## One System, Two Superpowers ## Define once, publish once, reuse everywhere The analyst owns the definition. Business users get governed, ready-to-use data in every reporting tool, and nothing changes downstream until the analyst publishes it. THE ANALYST ### Own the logic, skip the tickets Write SQL or point at a table, view or pattern, describe the output schema, publish. Every report built on the mart uses the definition you own and shows the SQL behind its numbers. ![Own the logic, skip the tickets](/images/features/data-mart-management/narrative-left.png) Your SQL, your rules — packaged for the entire organization. THE BUSINESS USER ### Clean data, zero setup Browse the Data Marts your team has published. Pull them into Google Sheets, Excel or Looker Studio, or ask in Claude or ChatGPT via OWOX MCP. No joins, filters or warehouse schemas to learn. ![Clean data, zero setup](/images/features/data-mart-management/narrative-right.png) Think of data marts as 'playlists' — curated by analysts, enjoyed by everyone. **One definition every report agrees on** — When the analyst defines the logic once, business users take the next column themselves, and the request queue stops refilling. ## For Data Teams For Data Teams ## Build reusable analytics assets Write SQL, define transformations, version your work — every data mart becomes a governed asset the whole company can query. ![Build a Data Mart from anything you already have](/images/features/data-mart-management/analyst-1.png) #### Build a Data Mart from anything you already have Start from a SQL query, a warehouse table, a view, a pattern or a connector's output. Or import up to 20 BigQuery tables and views in one action, with sharded tables collapsed into a single Pattern mart. ![Clean output schemas — aliases, descriptions, metadata](/images/features/data-mart-management/analyst-2.png) #### Clean output schemas — aliases, descriptions, metadata Rename fields, add descriptions and business-friendly aliases, or let the AI helper draft them from the schema and sample rows. Add calculated fields like CTR or ROAS as formulas that recompute at the grain each report asks for. ![Governance built in — who sees what, who edits what](/images/features/data-mart-management/analyst-3.png) #### Governance built in — who sees what, who edits what Publish when the mart is ready. Nothing reaches a destination before that. Then set who can report on it and who can edit it, and assign it to a context. The data team stays in charge of every governed asset. ## For Business Teams For Business Teams ## Access clean data instantly Browse ready-to-use datasets and pull them into Sheets, Looker Studio, or ask in Claude or ChatGPT via OWOX MCP — no SQL required. ![Your context, your data](/images/features/data-mart-management/business-1.png) #### Your context, your data Marketing sees marketing marts, finance sees finance. Project Contexts, set by your admin, show each team only the Data Marts that matter to them. ![Joinable Data Marts, right inside Google Sheets](/images/features/data-mart-management/business-2.png) #### Joinable Data Marts, right inside Google Sheets Pull two Data Marts into a Sheet and join them as if they were one. Blend orders with products or with sessions without writing SQL – the data team already wired the relationships. ![Self-serve inside a trusted perimeter](/images/features/data-mart-management/business-3.png) #### Self-serve inside a trusted perimeter Every Data Mart you can see was published by your data team, with the joins and definitions already in place. When a number is questioned, the analyst opens the report's SQL and checks it against the warehouse. ## Editions ## Included in all editions at no extra cost Individual Your analyst, just for you. $295 / month [Try free](https://www.owox.com/app-signup) Team Your analyst for your leadership team. $790 / month [Book a demo](/demo) Scale Your analyst for the whole company. Let's talk [Book a demo](/demo) [See full pricing & comparison →](/pricing) ## Why teams pick OWOX ## Everything business needs ![](/images/features/data-mart-management/benefit-1.svg) ### Governed metric definitions Centralize metric logic in one place, so everyone works from the same definitions, without rewriting SQL. ![](/images/features/data-mart-management/benefit-2.svg) ### Metrics you can trust Define KPIs once and reuse them everywhere – across Looker Studio, Sheets, Excel and AI assistants – with full control over changes. ![](/images/features/data-mart-management/benefit-3.svg) ### Define once, reuse everywhere Write your KPI logic once, then apply it across reports, dashboards, and clients – no duplication, no rework. ![](/images/features/data-mart-management/benefit-4.svg) ### Numbers you can check Every report exposes the SQL that produced it. When a figure is questioned, the analyst re-runs the query against your own warehouse. ## FAQ ## Frequently asked questions What is a data mart in OWOX? A Data Mart is a governed, reusable definition of data the analyst owns: a SQL query, a table, a view, a table pattern, a connector's output or a join of other marts, with an output schema that names and describes each field. Business users report on it in Google Sheets, Excel, Looker Studio, Slack, Teams, email or an AI assistant without writing SQL. How do data marts differ from raw database tables? Raw tables contain unprocessed data that requires SQL expertise to query correctly. Data marts apply business logic, joins, filters, and metric definitions — producing clean, ready-to-use datasets. They standardize how your organization interprets data. Can I version and manage changes to data marts? Yes. Changes to a Data Mart are published explicitly. Nothing downstream sees an edit until the analyst publishes it. What outputs can data marts power? Google Sheets and Excel reports, Looker Studio dashboards, scheduled Insights delivered to Slack, Teams, Google Chat or email, and questions asked in Claude or ChatGPT via OWOX MCP. Is this included in the free tier? Yes. Data Mart creation and management is available in every edition, including the free Data Intern plan and the Community self-managed edition. Do I need SQL skills to create data marts? Usually, yes. A SQL Data Mart needs SQL; a Table, View or Pattern mart needs none. The analyst defines the logic once, and business users consume it in Sheets, dashboards or AI without writing SQL. ## What users are saying ## Every claim has a receipt. Real things real customers said — each quote pinned to a specific claim, straight from the quotes database. A3re: trusting AI ![Nodari Rizun](https://cdn.owox.ai/www/webflow/6a7b298b2ca5055443187566_nodari-headshot.png/public)Nodari RizunFounder & CEO, Pürblack® > _“AI, by the nature of the models, will hallucinate. And because of that, you need something which will create guardrails to ensure that there are no hallucinations, that you can trust your data.”_ C9re: one source of truth ![Mark Simmons](https://cdn.owox.ai/www/webflow/6a7b298b2b9daab0ade631d7_mark-headshot.png/public)Mark SimmonsCMO, Pürblack® > _“We had six or seven different channels and no single source of truth — it was almost impossible, a lot of guesswork.”_ E7re: getting time back ![Nodari Rizun](https://cdn.owox.ai/www/webflow/6a7b298b2ca5055443187566_nodari-headshot.png/public)Nodari RizunFounder & CEO, Pürblack® > _“We regained time. And time is the one resource that never comes back.”_ ## Ready to structure your data? Define your Data Marts once and let every report reuse them. [Get started free](https://www.owox.com/app-signup?utm_source=owox.com&utm_medium=website&utm_campaign=features&utm_content=hero) ![Data Mart Management](/images/features/data-mart-management/hero.png) ## References Pages this page links to, on this site and on docs.owox.com. Where the page has a Markdown twin, its address follows the link. - [Get started free](https://www.owox.com/app-signup?utm_source=owox.com&utm_medium=website&utm_campaign=features&utm_content=hero) - [Read the docs →](https://docs.owox.com/docs/getting-started/core-concepts) - [Try free](https://www.owox.com/app-signup) - [Book a demo](https://www.owox.com/demo) — /demo.md - [See full pricing & comparison →](https://www.owox.com/pricing) — /pricing.md