Skip the 6-month semantic layer project

Declare relationships between Data Marts once. Business users get blended data from Ads, CRM, and product — without writing SQL.

app.owox.com/data-marts/joinable-data-marts
Declare relationships between Data Marts once. Business users get blended data from Ads, CRM, and product — without writing SQL.
Trusted, proven, recognized

The analytics system teams actually use

170K+
Users trust OWOX[1]
Analysts, marketers, and data teams across 20+ industries
4.9★
Rating on G2[2]
“A trusted data analytics partner” — verified review
365K+
Data marts delivered
Created and served by OWOX to business users
79K
npm installs[3]
Self-hosted OWOX Community Edition on GitHub
One Layer, Two Audiences

The semantic layer without building one

Joinable Data Marts give analysts a lightweight way to declare relationships, and give business users the blended data they need — without anyone writing a line of SQL at query time.

THE ANALYST

Declare relationships, not a full data model

Pick two Data Marts, choose the join keys, set output aliases. That's it. No 200-page LookML repo, no central modeling team - just relationships that evolve with the business. Internal SQL is auto-generated with proper aggregation.

Declare relationships, not a full data model
01One join at a time. Always current. Never frozen.
THE BUSINESS USER

Just pick the columns you need

Native and joined fields appear in the same picker — in Google Sheets, Looker Studio, or AI prompts. Blend ads with CRM, marketing with sales, product with finance. The join happens behind the scenes.

Just pick the columns you need
02No SQL, no joins, no waiting on the data team.
A semantic layer that grows with your business
New CRM field today? Add it to the Data Mart, expose it in the relationship, and every existing report can use it tomorrow. No quarterly modeling sprints.
For Data Teams

Declare relationships, not a full data model

Pick two Data Marts, choose the join keys, set output aliases. Relationships evolve with the business — no big-bang modeling project required.

Skip the 6-month semantic-layer project

Traditional semantic layers take months to build and break the moment your data evolves. Joinable Data Marts give you the same outcome — incrementally, in days.

Traditional semantic layers take months to build and break the moment your data evolves. Joinable Data Marts give you the same outcome — incrementally, in days.

One join at a time — no big-bang data modeling

Pick two Data Marts, choose the join keys, and you're done. No 200-page LookML repo, no central modeling team — just relationships that match how your business already works.

Pick two Data Marts, choose the join keys, and you're done. No 200-page LookML repo, no central modeling team — just relationships that match how your business already works.

Business-friendly field names, built in

Set output aliases on each Data Mart and per-field overrides on joins. Consumers see "Campaign Cost" — not gads_campaign_cost_amt_usd_v2.

Set output aliases on each Data Mart and per-field overrides on joins. Consumers see "Campaign Cost" — not gads_campaign_cost_amt_usd_v2.
Traditional semantic layers take months to build and break the moment your data evolves. Joinable Data Marts give you the same outcome — incrementally, in days.
Pick two Data Marts, choose the join keys, and you're done. No 200-page LookML repo, no central modeling team — just relationships that match how your business already works.
Set output aliases on each Data Mart and per-field overrides on joins. Consumers see "Campaign Cost" — not gads_campaign_cost_amt_usd_v2.
For Business Teams

Just pick the columns you need

Native and joined fields appear in the same picker. Blend ads, CRM, and product data — no SQL, no waiting on the data team.

Blend ads, CRM, and product data — no SQL

Pull spend from your Ads Data Mart and matching pipeline from CRM into the same report. The join happens behind the scenes; you just pick the columns.

Pull spend from your Ads Data Mart and matching pipeline from CRM into the same report. The join happens behind the scenes; you just pick the columns.

Just pick the columns you need

Native and joined fields appear in the same picker — in Google Sheets Extension, Looker Studio, or AI prompts. Just pick the columns you need; the join runs behind the scenes.

Native and joined fields appear in the same picker — in Google Sheets Extension, Looker Studio, or AI prompts. Just pick the columns you need; the join runs behind the scenes.

A semantic layer that grows with your business

New CRM field today? Add it to the Data Mart, expose it in the relationship, and every existing report can use it tomorrow. No quarterly modeling sprints.

New CRM field today? Add it to the Data Mart, expose it in the relationship, and every existing report can use it tomorrow. No quarterly modeling sprints.
Pull spend from your Ads Data Mart and matching pipeline from CRM into the same report. The join happens behind the scenes; you just pick the columns.
Native and joined fields appear in the same picker — in Google Sheets Extension, Looker Studio, or AI prompts. Just pick the columns you need; the join runs behind the scenes.
New CRM field today? Add it to the Data Mart, expose it in the relationship, and every existing report can use it tomorrow. No quarterly modeling sprints.
Editions

Available in all editions

Most flexible & free

Community

Self-Managed

Self-managed, full control

Community

Forever free & growing on GitHub

For teams automating reporting in Corporate DWH while valuing data autonomy: gaining full control over data connectivity and enablement

Create data marts from your DWH
Create data marts from external sources (Meta, Google, TikTok)
Enable data marts in Google Sheets & Data Studio
Automate data refreshes
No credentials sharing
Get started

MOST POPULAR

Team

OWOX Cloud

Best for teams

Team

Starts at $875/mo + $35/seat (5 seats included)

For small and mid-size teams looking to automate collaborative reporting & get AI insights

Everything in Starter, plus:
Automate AI Insights to Email, Google Chat, MS Teams, or Slack
Share credits across seats
500 credits / mo included
Set up data marts in Multiple Projects
Talk to Sales
Enterprise

Self-Managed

For security-first teams

Enterprise

Custom contract

For organizations looking for a tailored self-managed solution with an extra layer of flexibility, security & support included

Chat with data in your corporate messenger
Automate AI Insights Delivery to Email, G Chat, MS Teams, or Slack
Advanced Security & Control
Advanced User Management
Advanced Monitoring & Logging
Talk to Sales
Why teams pick OWOX

Everything business needs

Outcomes your company gets the moment your data marts go live.

Centralized metric definitions

Define KPIs once in a semantic layer and reuse them across reports, tools, and teams without rewriting logic.

One truth for every metric

Track revenue, CAC, margin, and more – from a single governed system that aligns every stakeholder.

Aligned decision-making

Make confident decisions faster, knowing everyone sees the same numbers and definitions.

Audit-ready reporting

Back every number with transparent, standardized logic – ready for stakeholder reviews or audits anytime.

Social proof

Every claim has a receipt.

Stats with comment threads attached — like a colleague verifying your numbers in a shared sheet.

170,000
Users on OWOX Platform — and growing 40% year-over-year.
B2
cell "users on platform"
SM
Sarah M.
Head of Analytics, Retail
3d ago

We migrated 200+ reports from Looker to OWOX Data Marts. Our team now self-serves without filing a single Jira ticket. Easily the best infrastructure decision we made this year.

✓ Verified
12 min
Median time-to-first-report for new OWOX users. No onboarding calls required.
C4
cell "time to first report"
DL
David L.
Data Lead, SaaS
Sarah M.

Connected BigQuery, set up 37 data marts, built a data model and had live reports in Sheets in under 15 minutes. My team thought I was joking when I showed them how they can now get live reports right in their sheets.

✓ Verified
FAQ

Frequently asked questions

What are Joinable Data Marts?
+
How is this different from a traditional semantic layer?
+
Do business users need to write SQL?
+
What happens with 1-to-many joins?
+
Is the generated SQL transparent?
+
Which editions include Joinable Data Marts?
+

Ready to skip the modeling sprint?

Declare your first join in minutes — and let every report pull blended data, no SQL required.