OWOX Data Marts
🏷 Self-Service Analytics Platform
Section titled “🏷 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 | 💬 Community | 🆘 Create an Issue
✨ Why We Built This
Section titled “✨ 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.
🚀 What You Can Do with OWOX Data Marts
Section titled “🚀 What You Can Do with OWOX Data Marts”📘 Create a Data Mart Library
Section titled “📘 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
Section titled “📤 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
Section titled “🧾 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
Section titled “📅 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
Section titled “🛠 Installation Guide”OWOX Data Marts can be run just about anywhere in minutes.
Here’s how to get started locally on your machine:
-
Install Node.js (version 22.16.0 or higher)
If it’s not installed yet, download it here
-
Open your terminal and run:
Terminal window npm install -g owox(You may see warnings - they’re safe to ignore)
-
Start OWOX Data Marts locally
Terminal window owox serve(You should see something like: 🚀 Starting OWOX Data Marts… 📦 Starting server on port 3000…)
-
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
Section titled “🔌 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
Section titled “Data Sources”| Name | Status | Links |
|---|---|---|
| Facebook Ads | 🟢 Public | Get started |
| Open Exchange Rates | 🟢 Public | Get started |
| Bank of Canada | 🟢 Public | Get started |
| LinkedIn Ads | 🟢 Public | Get started |
| LinkedIn Pages | 🟢 Public | Get started |
| TikTok Ads | 🟢 Public | Get started |
| X Ads (former Twitter Ads) | 🟢 Public | Get started |
| Criteo Ads | 🟢 Public | Get started |
| Microsoft Ads (former Bing Ads) | 🟢 Public | Get started |
| Reddit Ads | 🟢 Public | Get started |
| Hotline | ⚪️ In Discussion | Discussion |
| Shopify Ads | ⚪️ In Discussion | Discussion |
| Google Business Profile | ⚪️ In Discussion | Discussion |
Data Storages
Section titled “Data Storages”| Name | Status | Links |
|---|---|---|
| Google Sheets | 🟢 Public | Readme |
| Google BigQuery | 🟢 Public | Readme |
| AWS Athena | 🟢 Public | Readme |
If you find an integration missing, you can share your use case and request it in the discussions
🧑💻 Contribute
Section titled “🧑💻 Contribute”Want to build a connector? We’d love your help.
To contribute to existing integrations or create a new one:
- Join our community
- Read the contributor guide
- Watch or read this tutorial of how we built a new connector in < 25 minutes
- Check open requests
All you need to get started is the desire to build a new connector. No software installation is required on your computer.
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
Section titled “📌 License”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
⭐ Like this project? Star our awesome repo »