Connector

Enable business reporting from your AWS Athena data

Turn your data warehouse into a real reporting library. Connected Data Marts, ready for Microsoft Excel.

AWS AthenaConnected
Data MartPublishedone definition
Microsoft ExcelDaily 09:00
Refreshed on a schedule. No exports, no copy-paste.

Get started free

Hand this to your AI

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

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

S01 · Step 1

Start from your AWS Athena data

Pick the Athena database that holds the data your workbooks will read.

  • Nothing to move or copy.
AWS AthenaYour data warehouseDatabase
Unified Ad SpendConnected dataNothing to move or copy

S02 · Step 2

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.
Data martsUnified Ad SpendAISessionsAI
Unified Ad SpendData modelplatform_roas · platform_cpa
Unified Ad Spend + Sessions
SessionsJoined by a shared key

S03 · Step 3

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.
OWOX add-inSigned inUnified Ad SpendcostInUsdclicksimpressionsCreate & Run
Microsoft ExcelYour columns staycostInUsdclicksimpressions

S04 · Step 4

Keep Microsoft Excel connected to the same data

Ask in Claude, export to a sheet, share with the boss.

  • One source, every tool.
Unified Ad SpendOne source
ClaudeAsk in chat
Google SheetsExport to a sheet
Your bossShare the answer

Recent updates

Why OWOX

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.

Book a callGet started free

Trust

The Data Partner You Can Trust

users

175K Source: Internal OWOX data as of 2026-11-11

Executives and data analysts across 20+ industries

G2 rating

4.9★2

“A trusted data analytics partner” — verified review

npm installs

171K3

In Open Source We Trust

Customers