Enable business reporting from your Databricks data
Turn your data warehouse into a real reporting library. Connected Data Marts, ready for Microsoft Excel.
DatabricksConnected
Microsoft ExcelDaily 09:00Finance wants Databricks numbers in Excel, so someone exports a CSV every week and every copy drifts.
Paste this into your AI assistant. It builds Data Marts on your Databricks tables and binds one to an Excel worksheet through the OWOX add-in, so the workbook refreshes from the same SQL instead of a pasted export.
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-microsoft-excel.md. The task: turn the Databricks tables behind our monthly finance report into a Data Mart and bind it to an Excel worksheet with the OWOX add-in, with the columns, filters and sort finance uses today. 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 workbooks report 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.
Pull Databricks data into Microsoft Excel with the add-in
Sign in, choose a published Data Mart, set columns, filters and sort, then Create & Run binds the report to the worksheet.
- Your own columns and formulas stay put on refresh.
Microsoft ExcelYour columns staycostInUsdclicksimpressionsKeep Microsoft Excel 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 Microsoft Excel
Excel reports keep their layout while the numbers come from governed Data Marts on Databricks.
- You own the data. Your data lives in your own Databricks lakehouse; the workbook shows what your tables return on refresh.
- Defined once in SQL. Analysts define metrics on your Delta tables once; every Data Mart and every destination reuses them.
- Your layout survives. A refresh rewrites only the imported columns; the columns, formulas and formats you added stay.
- Pull on demand. The add-in asks OWOX for the data when you refresh; there is no schedule to manage.
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.