Enable business reporting from your Snowflake data
Turn your data warehouse into a real reporting library. Connected Data Marts, ready for Microsoft Excel.
Snowflake numbers reach Microsoft Excel as CSV downloads, and nobody knows which file on the shared drive is current.
Paste this into your AI assistant. It builds Data Marts on your Snowflake data with OWOX Data Marts and pulls a published one into a Microsoft Excel workbook through the OWOX Data Marts add-in.
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/snowflake-connector-to-microsoft-excel.md. The task: build a Data Mart on our Snowflake data and pull it into a Microsoft Excel workbook with the add-in, with the columns and filters our team reviews each month, instead of a CSV download. 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 Snowflake data
Pick the Snowflake database and schema behind the workbook you keep rebuilding.
- Nothing to move or copy.
Build a reporting library in Snowflake
Each Data Mart in Snowflake is a ready report, described by AI, and joins to other Data Marts through the model.
- Business users browse reports, not tables.
Pull Snowflake data into Microsoft Excel with the add-in
Sign in to the OWOX Data Marts add-in, choose a published Data Mart, set columns and filters, then Create & Run.
- Excel pulls the data when you refresh; nothing is pasted.
Keep Microsoft Excel connected to the same data
Ask in Claude, export to a sheet, share with the boss: the workbook reads the same Data Marts as every other tool.
- One source, every tool.
- 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 Snowflake reporting
Stop rebuilding the same export. The OWOX Data Marts add-in refreshes a worksheet from a Data Mart you defined on Snowflake.
- You own the data. The numbers come from your Snowflake, through Data Marts your analysts defined.
- Your own columns stay. A refresh rewrites only the imported columns; your own columns and formulas stay, and so do the formats on imported columns.
- Pull, on your terms. Excel asks OWOX for the data when you refresh the report. There is no schedule and nothing is pushed into the workbook.
- Same account as OWOX. The Microsoft account in Excel uses the same email as your OWOX profile.
- One source, every tool. The same Data Marts feed Sheets, dashboards, Claude and ChatGPT.
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.