Enable business reporting from your Google BigQuery data
Turn your data warehouse into a real reporting library. Connected Data Marts, ready for Slack.
Google BigQueryConnected
SlackDaily 09:00A drop in yesterday's numbers sits in Google BigQuery until someone thinks to query it, often days later.
Paste this into your AI assistant. It turns your Google BigQuery tables into connected Data Marts with OWOX Data Marts and sends a daily report from them to Slack, with the biggest change explained.
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-slack.md. The task: send a daily report from my Data Marts on Google BigQuery to our Slack channel: yesterday's key measures against the day before, with a short explanation of the biggest change. 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 Slack 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 Slack
Schedule a Data Mart's report to a Slack channel, with a short analysis written under the numbers.
- The team sees the numbers where it already works.
SlackScheduledWeekly paid media reportcostInUsdclicksimpressionsAnalysisSpend and clicks are grouped by ad platform for the week.Check which platform shows the highest platform_cpa first.Read platform_roas next to it before moving any budget.Keep Slack 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
Decisions happen in Slack, so the report goes there on a schedule instead of waiting in a dashboard.
- 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.
- Sent when it matters. Choose to send always, or only when the result is empty or not empty.
- On your schedule. Send daily, weekly or on a condition to any Slack channel.
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.