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
Build a library of reusable data marts
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.
step-by-step

How our data collection works?

Step 1: Add Your Data Storage

Decide where do you want your data to be stored - any data warehouse

Step 2: Select data source

Choose your app, give necessary permissions to account.

Step 3: Configure the fields

Select the fields your want to import. You can get the fields available in the API.

Step 4: Run & get your data

You're ready to go. Run connectors & set update frequency.

Step 5: Connect more sources

You don't want single-source reports, right? Collect more data!

Step 6: Configure Data Marts

Build a collection of data marts: SQL, tables, views or connectors.

Step 7: Connect BI Tools & more

Select a data destination: Sheets, Looker Studio, Email or Chat tools.

Step 8: Run AI Insights

Get focused on data insights, set delivery and forget about routine.

Editions

Available in all editions

Most flexible & free

Community

Self-Managed

Self-managed, full control

Community

Forever free

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 Ads & more)
Enable data marts in Google Sheets, Looker Studio, and Excel
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, Microsoft 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, Google 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.