Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session.

You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert OWOX / owox-data-marts Public Notifications You must be signed in to change notification settings Fork 30 Star 221 main124 Branches0 TagsGo to fileCodeOpen more actions menuFolders and filesNameNameLast commit messageLast commit dateLatest commitlaskevychfix(backend): OOM during AI metadata generation (#1235)failureMay 22, 2026b808862 · May 22, 2026History1,375 CommitsOpen commit details1,375 Commits.changeset.changesetfeat(connectors): add default fields to connector endpoints (#1231)May 21, 2026.github/workflows.github/workflowsfix(ci): align changesets publish flags (#1176)Apr 30, 2026appsappsfix(backend): OOM during AI metadata generation (#1235)May 22, 2026docsdocsrefactor(backend): pre-clear Google Sheets imported rectangle before …May 22, 2026licenseslicensesEnterprise License added (#739)Nov 19, 2025packagespackagesfeat(connectors): add default fields to connector endpoints (#1231)May 21, 2026toolstoolsfeat(generate-shrinkwrap): implement retry logic for npm install duri…Mar 13, 2026.env.example.env.examplefeat(owox): add CORS support for Google Sheets Extension (#1075)Mar 24, 2026.gitattributes.gitattributesfeat(docs): add changelog to the docs.owox.com (#375)Jul 31, 2025.gitignore.gitignorefeat: output controls per report (filters, sort, limit) (#1189)May 11, 2026.lintstagedrc.json.lintstagedrc.jsonfeat: update build scripts and configurations for better dependency m…Sep 25, 2025.markdownlint-cli2.mjs.markdownlint-cli2.mjscomplete project research for integration testing suite (#1069)Mar 30, 2026.markdownlint.json.markdownlint.jsonfix(markdownlint): disable md060 rule (#753)Nov 27, 2025.npmrc.npmrcfix audit (#743)Nov 26, 2025.prettierignore.prettierignorefeat: add data-table tag handler for email report templates (#904)Feb 26, 2026.prettierignore.root.prettierignore.rootorg: script fix (#312)Jul 18, 2025DockerfileDockerfilechore: Add NODE_OPTIONS environment variable to suppress Node.js de…Mar 19, 2026LICENSE.mdLICENSE.mdEnterprise License added (#739)Nov 19, 2025README.mdREADME.mdfeat: rebrand Looker Studio to Data StudioMay 8, 2026eslint.config.mjseslint.config.mjsfeat(org): add test, build, and markdownlint to github workflowsJul 15, 2025package-lock.jsonpackage-lock.jsonVersion Packages (#1178)May 14, 2026package.jsonpackage.jsonfix/audit: update dependencies and package overrides across workspace (…Mar 31, 2026prettier.config.mjsprettier.config.mjsfeat(org): add test, build, and markdownlint to github workflowsJul 15, 2025tsconfig.jsontsconfig.jsonorg: code format (#281)Jul 11, 2025View all filesRepository files navigationOWOX 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, Data 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: Install Node.js (version 22.16.0 or higher) If it’s not installed yet, download it here Open your terminal and run: npm install -g owox (You may see warnings – they’re safe to ignore) Start OWOX Data Marts locally 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 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 Shopify 🟢 Public Get started TikTok Ads 🟢 Public Get started X Ads (former Twitter Ads) 🟢 Public Get started Shopify Ads ⚪️ In Development Hotline ⚪️ In Discussion Discussion Google Business Profile ⚪️ In Discussion Discussion Data Storages Name Status Links Google BigQuery 🟢 Public Readme AWS Redshift 🟢 Public Readme AWS Athena 🟢 Public Readme Snowflake 🟢 Public Readme Databricks 🟢 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 » About Open-Source Self-Service Analytics Platform www.owox.com Topics bigquery data facebook sql reddit dashboard athena analytics linkedin reporting snowflake data-analysis redshift sql-editor databricks sheets self-service tikto