Enable business reporting from your Google BigQuery data
Turn your data warehouse into a real reporting library. Connected Data Marts, ready for Google Chat.
Google BigQueryConnected
Google ChatDaily 09:00Numbers from Google BigQuery reach the team's Google Chat space only when an analyst has time to run the query.
Paste this into your AI assistant. It turns your Google BigQuery tables into connected Data Marts with OWOX Data Marts and posts a scheduled report from them to your Google Chat space.
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-insights-to-google-chat.md. The task: post a weekly report from my Data Marts on Google BigQuery to our Google Chat space: the key measures, what changed against last week, and why in plain words. 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 your Google Chat reports draw on.
- 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.
Send Google BigQuery reports to Google Chat
Schedule a Data Mart's report to a Google Chat space, with a short analysis written under the numbers.
- The team sees the numbers where it already works.
Google ChatScheduledWeekly paid media reportcostInUsdclicksimpressionsAnalysisWeekly spend, clicks and impressions for each ad platform.Start with the platform whose platform_cpa stands out most.Then check platform_roas for the same platform.Keep Google Chat 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
Your team already talks in Google Chat, so the report lands in the space on a schedule.
- You own the data. It lives in your own BigQuery project, not inside an ad platform or a CRM.
- SQL first, AI second. Every insight starts with a number calculated in SQL on BigQuery, and the analysis is written around it.
- Same data, same answer. The space sees the same Data Mart as the sheet and the dashboard, so the numbers match.
- On your schedule. Send daily, weekly or on a condition to the space.
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.