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 | 🌐 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
Google Sheets Edition
Section titled “Google Sheets Edition”Alternatively, you can run any of our connectors using Google Sheet templates we’ve developed for OWOX Data Marts Apps Script Edition
- Pick your platform (eg, Facebook Ads) from existing integrations
- Make a copy of the template
- Add your credentials — they stay private
- Run the connector to pull your data
- Schedule it for hourly/daily/weekly/monthly updates
For more details - watch the webinar replay - 🎥 Own Your Data: How Data Analysts Can Connect Any Data
🔌 Available Connectors
Section titled “🔌 Available Connectors”OWOX Data Marts includes growing library of JavaScript 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 Google Sheets & BigQuery
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 |
| 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 | Environment | Links |
|---|---|---|---|
| Google Sheets | 🟢 Public | Apps Script | Readme |
| Google BigQuery | 🟢 Public | Node.js, Apps Script | Readme |
| AWS Athena | 🟢 Public | Node.js | 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 »