OWOX Data Marts

🏷 Self-Service Analytics Platform

OWOX Data Marts is your way to create a data mart library and empower business users with spreadsheet reports and dashboards — in minutes.

📘 Quick Start Guide | 📚 Documentation | 🌐 Website | 💬 Slack Community | 🆘 Create an Issue

✨ Why We Built This

Data analysts’ work means nothing unless business users can play with the data freely.

However, most self-service analytics initiatives fail because they compromise either the data analysts’ control or the business users’ freedom.

At OWOX, we value both:

• Data analysts orchestrate data marts defined either by SQL or by connectors to sources like Facebook Ads, TikTok Ads, and LinkedIn Ads.
• Business users enjoy trusted reports right where they want them — in spreadsheets or dashboards.

At OWOX, we believe data analysts shouldn’t have to waste time on CSV files and one-off dashboards. Business users shouldn’t have to be forced to use complex BI tools either.

---

owox-data-marts-demo-light.mp4

---

🚀 What You Can Do with OWOX Data Marts

📘 Create a Data Mart Library

Bring together data from your warehouse (BigQuery, Snowflake, etc.), APIs, or spreadsheets – and turn it into fast, reusable artifacts that you can manage & share:

• Connectors to any marketing, financial, or CRM data that you can collect into AWS Athena or Google BigQuery (more supported DWHs are being developed as you read this)
• Custom SQL
• Tables & views
• Table patterns (eg, events_2025*)

📤 Deliver Trusted Data Anywhere

Connect your Data Marts to Google Sheets, Looker Studio, or Excel – empowering business teams with reports they need to make decisions.

🧾 Define a Semantic Layer

Document KPIs and metrics once, and keep every dashboard, pivot table, and report in sync with the same numbers & logic behind calculations – no matter the tool.

📅 Automate Everything

Use the advanced scheduler to refresh both Data Marts and exports at any time, fully automated and managed from a single place

🛠 Installation Guide

OWOX Data Marts can be run just about anywhere in minutes.
Here’s how to get started locally on your machine:

1. Install Node.js (version 22.16.0 or higher)

   If it’s not installed yet, download it here

2. Open your terminal and run:

   npm install -g owox

   (You may see warnings - they’re safe to ignore)

3. Start OWOX Data Marts locally

   owox serve

   (You should see something like: 🚀 Starting OWOX Data Marts... 📦 Starting server on port 3000...)

4. Open your browser and go to http://localhost:3000 to explore! 🎉

For more details on the types of deployment in your infrastructure, check out our Quick Start Guide

🔌 Available Connectors

OWOX Data Marts includes growing library of data connectors that:

• Pull data from any APIs like Facebook Marketing, TikTok Ads, LinkedIn Ads, etc.
• Require zero external tools or sharing credentials
• Don't require ANY data engineering resources
• Free, open-source, and customizable
• Give full control over the logic
• Works with BigQuery and AWS Athena

Data Sources

Name	Status	Links
Bank of Canada	🟢 Public	Get started
Criteo Ads	🟢 Public	Get started
Facebook Ads	🟢 Public	Get started
GitHub	🟢 Public	Get started
Google Ads	🟢 Public	Get started
LinkedIn Ads	🟢 Public	Get started
LinkedIn Pages	🟢 Public	Get started
Microsoft Ads (former Bing Ads)	🟢 Public	Get started
Open Exchange Rates	🟢 Public	Get started
Open Holidays	🟢 Public	Get started
Reddit Ads	🟢 Public	Get started
TikTok Ads	🟢 Public	Get started
X Ads (former Twitter Ads)	🟢 Public	Get started
Hotline	⚪️ In Discussion	Discussion
Shopify Ads	⚪️ In Discussion	Discussion
Google Business Profile	⚪️ In Discussion	Discussion

Data Storages

Name	Status	Links
Google BigQuery	🟢 Public	Readme
AWS Athena	🟢 Public	Readme
Snowflake	🟢 Public	Readme

If you find an integration missing, you can share your use case and request it in the discussions

🧑‍💻 Contribute

Want to build a connector? We'd love your help.

To contribute to existing integrations or create a new one:

• Read the Contributor Guide
• Check Issues
• Join Discussions
• Join Slack Community

Whether you're adding a new platform, tweaking an existing connector, or improving docs, we'll support and spotlight you.

We're building this with the community, not just for it.

📌 License

Except for Enterprise-grade features, OWOX Data Marts is free for internal or client use, not for resale in a competing product. The project uses a dual-license model:

• Connectors (packages/connectors) are distributed under the MIT License
• Platform (all other files and directories) is distributed under the ELv2 License

Enterprise features are licensed under the Enterprise License and are located in the apps/backend/src/data-marts/data-destination-types/ee directory or source code files that contain .ee. in their file name. Pricing for Enterprise features is available on our pricing page.

---

⭐ Like this project? Star our awesome repo »