Enable business reporting from your Databricks data
Turn your data warehouse into a real reporting library. Connected Data Marts, ready for Data Studio dashboards.
DatabricksConnected
Data StudioDaily 09:00Metrics on Databricks get redefined inside each Data Studio chart, so the dashboard and your own query disagree.
Paste this into your AI assistant. It builds a Data Mart on your Databricks tables with OWOX Data Marts and connects Data Studio to it, so metrics live in SQL, not inside each chart.
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-connector-to-data-studio.md. The task: build a Data Mart on my Databricks tables with my core metrics defined in SQL and connect it to Data Studio, so every chart on my dashboard reads that one definition. 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 dashboards read from.
- 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.
Feed Data Studio dashboards from Databricks
A dashboard reads a governed Data Mart, so metrics live in SQL, not inside each chart. The same Data Mart also reaches a spreadsheet or an AI assistant.
- Fewer broken dashboards, one number everywhere.
Data StudioUnified Ad Spend
Google SheetsSame Data Mart
ClaudeSame Data MartKeep Data Studio connected to the same data
Ask in Claude, export to a sheet, share with the boss.
- One source, every tool.
ClaudeAsk in chatGoogle 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 Data Studio
Data Studio draws the charts; the business logic stays upstream in governed Data Marts on Databricks.
- You own the data. Your data lives in your own Databricks lakehouse; dashboards read governed Data Marts built on it.
- Defined once in SQL. Analysts define metrics on your Delta tables once; every Data Mart and every destination reuses them.
- Governed dashboards. Every dashboard runs on the same Data Marts, with no duplicated custom fields or conflicting metrics.
- Less maintenance. Update a definition once in your data warehouse and every connected dashboard follows.
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.