OWOX Data Marts connects Google Sheets™ to your data warehouse – BigQuery™, Snowflake, Databricks, Amazon Redshift, or Amazon Athena – so data teams can build a reusable library of data marts and share them with business users who run reports without writing SQL.

HOW IT WORKS

1. Data analysts create data marts using SQL, source tables, views, or connectors.
2. Share data marts with colleagues (and teams) – they don't need warehouse credentials.
3. Business users select a data mart, pick the columns they need, add filters, set sorting and row limits, then run the report directly in Google Sheets™.
4. Need more data? Add columns from joined data marts without touching SQL. Remove columns you don't need. Every join is fully traceable in the OWOX control panel at app.owox.com.
5. Schedule automatic refreshes by your rulles: hourly, daily, weekly, custom or every 15 minutes – and manage all reports and schedules from a single dashboard.

WHAT YOU CAN DO

(1) Query any supported warehouse from Google Sheets™ with no row limits.
(2) Build, publish, join & reuse query library your whole team trusts.
(3) Let business users self-serve: pick columns, filter, sort, and schedule – no SQL, no ad-hoc requests from them.
(4) Add One More Column: users extend reports by pulling fields from joined data marts on the fly.
(5) Auto-generate pivot tables and charts with one click.
(6) Collect marketing data into your data warehouse from Google Ads™, Facebook Ads, TikTok Ads, Reddit Ads, Shopify, and more.
(7) Deliver deterministic SQL-based insights to Slack, Google Chat™, Microsoft Teams, or by Email.
(8) Track every report, schedule, and data mart from a single control panel.

SUPPORTED DATA WAREHOUSES

Google BigQuery™, Snowflake, Databricks, AWS Redshift, Amazon Athena.

OWOX BigQuery™ Data Marts is already trusted by 170,000+ users. Free to start.