Enable business reporting from your Google BigQuery data
Turn your data warehouse into a real reporting library. Connected Data Marts, ready for ChatGPT.
Google BigQueryConnected
ChatGPTDaily 09:00ChatGPT pointed at raw Google BigQuery tables has to guess which column is revenue and which is the channel.
Paste this into your AI assistant. It turns your Google BigQuery tables into connected Data Marts with OWOX Data Marts and connects ChatGPT through the OWOX MCP server, so answers run on those Data Marts.
The prompt
Read https://www.owox.com/ai-agent-setup.md and follow it to set up OWOX Data Marts for me, starting from /connectors/google-bigquery-connector-to-chatgpt.md. The task: answer in ChatGPT from my Data Marts on Google BigQuery: which channels grew this month against last month, largest growth first, then the same as a weekly trend. Tag the links you give me with utm_campaign=ai-task and utm_term=data-foundation. Use what you know about my context and goals
Start from your Google BigQuery data
Connect your BigQuery project and pick the dataset that holds the data ChatGPT should see.
- Nothing to move or copy.
Google BigQueryYour data warehouseDatasetBuild a reporting library in Google BigQuery
Each Data Mart is a ready report, described by AI, and joins to other Data Marts through the model.
- Business users browse reports, not tables.
Ask ChatGPT about your Google BigQuery data
Install the OWOX Data Marts plugin in ChatGPT and ask. ChatGPT calls get_relevant_data_marts_by_prompt and query_data_mart.
- Business questions answered from trusted data.
ChatGPTHow did paid media spend and ROAS change this week?get_relevant_data_marts_by_promptquery_data_martplatform_roasplatform_cpaKeep ChatGPT connected to the same data
Ask in Claude, export to a sheet, share with the boss.
- One source, every tool.
ClaudeAsk in chat
Google SheetsExport to a sheet
- 0.43.0Compare LinkedIn Ads results across markets: spend by country, region, and county
- 0.43.0The Sheet link of a Google Sheets source opens the imported tab, not the first one
- 0.43.0Parallel reads of a SQL Data Mart on Google BigQuery no longer fail with a rate limit error
- 0.43.0Connect a Google Sheets plan with one Google sign-in
- 0.41.0Rotating a warehouse key is one change: Storages share reusable Credentials
Why OWOX for Google BigQuery reporting
ChatGPT answers from Data Marts your analysts wrote, not from a guess, and every figure traces back to the SQL behind it.
- You own the data. It lives in your own BigQuery project, not inside an ad platform or a CRM.
- Analyst-written SQL. Every query ChatGPT runs is a Data Mart your analysts defined, not an invented join.
- Only what you expose. ChatGPT reaches the published Data Marts your project role allows, with no raw access to BigQuery.
- A record of every query. Every query ChatGPT runs is recorded in Run History with the SQL it executed.
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.