Connector

Enable business reporting from your Google BigQuery data

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

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

Get started free

Hand this to your AI

Every Data Studio dashboard on Google BigQuery has its own custom query, so two dashboards show two revenues.

Paste this into your AI assistant. It turns your Google BigQuery tables into connected Data Marts with OWOX Data Marts and feeds Data Studio from them, so each metric is defined once.

The prompt

feed my Data Studio dashboards from connected Data Marts on Google BigQuery instead of custom queries, with one definition per metric, and list the dashboards to repoint

S01 · Step 1

Start from your Google BigQuery data

Connect your BigQuery project and pick the dataset that holds the data your dashboards read.

  • 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

Feed Data Studio dashboards from Google BigQuery

Turn on Available in Data Studio for a published Data Mart, then add the OWOX connector in Data Studio (Looker Studio).

  • Dashboards read governed data, not chart-level logic.
Data StudioUnified Ad Spend
Google SheetsSame Data Mart
ClaudeSame Data Mart

S04 · Step 4

Keep Data Studio 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

Dashboards stay a visualization layer: the metrics are defined once in a Data Mart on BigQuery, not rebuilt in every chart.

  • You own the data. It lives in your own BigQuery project, not inside an ad platform or a CRM.
  • Same numbers everywhere. A metric changed in the Data Mart changes in every connected dashboard.
  • Fields come with names. Field names and descriptions come from the output schema of the Data Mart.
  • You set the freshness. The cache lifetime says how long OWOX serves stored results before it reads BigQuery again.

Book a callGet started free

Trust

The Data Partner You Can Trust

users

175K Source: Internal OWOX data as of 2026-11-11

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