Connector

Enable business reporting from your Google BigQuery data

Turn your data warehouse into a real reporting library. Connected Data Marts, ready for an API.

Google BigQueryConnected
Data MartPublishedone definition
APIDaily 09:00
Refreshed on a schedule. No exports, no copy-paste.

Get started free

Hand this to your AI

Every app that reads Google BigQuery carries its own copy of the query, and the copies drift apart.

Paste this into your AI assistant. It turns your Google BigQuery tables into connected Data Marts with OWOX Data Marts, so apps and scripts read one Data Mart's rows over HTTP with an API key.

The prompt

let my apps and scripts read one Data Mart on Google BigQuery over HTTP with an API key instead of querying tables directly, and list the queries it replaces

S01 · Step 1

Start from your Google BigQuery data

Connect your BigQuery project and pick the dataset that holds the data your apps ask for.

  • Nothing to move or copy.
Google BigQueryYour data warehouseDataset
Unified Ad SpendConnected dataNothing to move or copy

S02 · Step 2

Build a reporting library in Google BigQuery

Each Data Mart is a ready report, described by AI, and joins to other Data Marts through the data model.

  • Business users browse reports, not tables.
Data martsUnified Ad SpendAISessionsAI
Unified Ad SpendData modelplatform_roas · platform_cpa
Unified Ad Spend + Sessions
SessionsJoined by a shared key

S03 · Step 3

Serve Google BigQuery data through an API

A client asks OWOX for a Data Mart's rows over HTTP with an API key and gets the rows back.

  • Your apps and scripts read the same governed data.
Your app or scriptHTTP request
APIUnified Ad SpendRows over HTTP
JSON rowscostInUsdclicksimpressions

S04 · Step 4

Keep the API connected to the same data

Ask in Claude, export to a sheet, share with the boss.

  • One source, every tool.
Unified Ad SpendOne source
ClaudeAsk in chat
Google SheetsExport to a sheet
Your bossShare the answer

Recent updates

Why OWOX

Why OWOX for Google BigQuery reporting

Developers read the same governed Data Marts as the business, over HTTP, instead of writing SQL against BigQuery in every app.

  • You own the data. It lives in your own BigQuery project, not inside an ad platform or a CRM.
  • No browser sign-in. An API key authenticates the client, so scripts and internal tools run unattended.
  • Rows, not a dashboard. The client gets the Data Mart's rows to use in its own code.
  • One definition of a metric. The app reads the Data Mart your analysts defined, so it matches the report.

Book a callGet started free

Trust

The Data Partner You Can Trust

users

166K Source: Internal OWOX data as of 2026-11-15

Executives and data analysts across 20+ industries

G2 rating

4.9★2

“A trusted data analytics partner” — verified review

npm installs

171K3

In Open Source We Trust

Customers