Enable business reporting from your Databricks data
Turn your data warehouse into a real reporting library. Connected Data Marts, ready for Google Chat.
DatabricksConnected
Google ChatDaily 09:00Questions about Databricks numbers keep landing in Google Chat, and someone has to run a query to answer each one.
Paste this into your AI assistant. It builds a Data Mart on your Databricks tables and schedules it to a Google Chat space, so the report and a short analysis arrive before anyone has to ask.
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/databricks-insights-to-google-chat.md. The task: schedule a Data Mart on our Databricks tables to post a daily KPI report with a short analysis to our team's Google Chat space every morning at 9:00. 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 Databricks data
Pick the Databricks catalog and schema that hold the data your Google Chat reports are built on.
- Nothing to move or copy: your Delta tables stay in Databricks.
DatabricksYour data warehouseCatalogmainSchemaBuild a reporting library in Databricks
Each Data Mart is a ready report over your Databricks tables, described by AI, and joins to other Data Marts through the model.
- Business users browse reports, not tables.
Send Databricks reports to Google Chat
Schedule a Data Mart to a Google Chat space daily, weekly or on a condition. The message carries the report and a short analysis under it.
- Reports reach the space where the team already talks.
Google ChatScheduledWeekly paid media reportcostInUsdclicksimpressionsAnalysisOne platform stands out on cost per acquisition.ROAS and spend together show where budget is working.Check ROAS first on the platform that spends the most.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.0Connect a Google Sheets plan with one Google sign-in
- 0.41.0Rotating a warehouse key is one change: Storages share reusable Credentials
- 0.41.0Dates from Google Sheets arrive as dates, not text
Why OWOX for Databricks and Google Chat
Google Chat gets reports built on governed Data Marts on Databricks, with the numbers calculated in SQL first.
- You own the data. Your data lives in your own Databricks lakehouse; each message is built from a governed Data Mart on it.
- Defined once in SQL. Analysts define metrics on your Delta tables once; every Data Mart and every destination reuses them.
- Native to Google Workspace. Insights reach the space where a Google Workspace team already talks.
- SQL first, AI second. Every insight starts with a number calculated in SQL, then narrated in plain language.
- On your schedule. Daily, weekly or conditional delivery to a Google Chat space.
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.