Enable business reporting from your Google BigQuery data
Turn your data warehouse into a real reporting library. Connected Data Marts, ready for Microsoft Teams.
Google BigQueryConnected
Microsoft TeamsDaily 09:00Managers in Microsoft Teams ask the same Google BigQuery questions every week, and an analyst answers each one by hand.
Paste this into your AI assistant. It turns your Google BigQuery tables into connected Data Marts with OWOX Data Marts and posts the answers to a Teams channel on a schedule, calculated in SQL.
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-microsoft-teams.md. The task: post a weekly report from my Data Marts on Google BigQuery to our Microsoft Teams channel, covering the questions managers ask most, with numbers calculated in SQL and explained briefly. 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 Microsoft Teams 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 Microsoft Teams
Schedule a Data Mart's report to a Teams channel, with a short analysis written under the numbers.
- The team sees the numbers where it already works.
Microsoft TeamsScheduledWeekly paid media reportcostInUsdclicksimpressionsAnalysisThis week's spend and clicks, split by ad platform.Compare platform_cpa across platforms to see where it is highest.platform_roas shows which spend is paying back; read it next.Keep Microsoft Teams 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
Microsoft Teams is where your organization collaborates, so the report arrives there 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.
- Every number has a source. The figures in the message come from a Data Mart on BigQuery, and the SQL behind them is visible in OWOX.
- On your schedule. Send daily, weekly or on a condition to any Teams channel.
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.