Enable business reporting from your AWS Athena data
Turn your data warehouse into a real reporting library. Connected Data Marts, ready for Microsoft Excel.
Finance wants AWS Athena numbers in Microsoft Excel, so each month an analyst exports a file and pastes it in.
Paste this into your AI assistant. It publishes a Data Mart on your AWS Athena data with OWOX Data Marts, so the team pulls it into Excel with the add-in and a refresh rewrites only the imported columns.
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/aws-athena-connector-to-microsoft-excel.md. The task: publish a Data Mart on my AWS Athena database that my finance team can pull into Microsoft Excel with the add-in, with the columns and filters they need and a refresh on request. 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 AWS Athena data
Pick the Athena database that holds the data your workbooks will read.
- Nothing to move or copy.
Build a reporting library in AWS Athena
Each Data Mart is a ready report, described by AI, and joins to other Data Marts through the data model.
- Business users browse reports, not tables.
Pull AWS Athena data into Microsoft Excel with the add-in
Sign in, pick a published Data Mart, set columns and filters, then Create & Run. A refresh rewrites only the imported columns.
- Your own columns and formulas stay put.
Keep Microsoft Excel connected to the same data
Ask in Claude, export to a sheet, share with the boss.
- 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 AWS Athena and Microsoft Excel
OWOX keeps AWS Athena for storage and puts governed Data Marts between it and Microsoft Excel, so every number has one definition.
- You own the data. It stays in your S3 and Athena. OWOX queries it in place and keeps no copy.
- Defined once. Analysts write the Data Mart in SQL once; every workbook that pulls it shows the same numbers.
- Your layout survives. Refresh rewrites only the imported columns; formulas and formats you added stay.
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.

