Enable business reporting from your AWS Athena data
Turn your data warehouse into a real reporting library. Connected Data Marts, ready for ChatGPT.
AWS AthenaConnected
ChatGPTDaily 09:00Business users want AWS Athena answers in ChatGPT, but nobody can tell which tables it may read or what they mean.
Paste this into your AI assistant. It connects ChatGPT to the AWS Athena Data Marts you choose through the OWOX MCP server, so it lists what each one measures and answers from their SQL.
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-chatgpt.md. The task: connect ChatGPT to my AWS Athena Data Marts through the OWOX MCP server, list what each one measures, then show last week's ad spend by channel from the marketing one. 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 ChatGPT may use.
- Nothing to move or copy.
AWS AthenaYour data warehouseDatabaseBuild 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.
Ask ChatGPT about your AWS Athena data
Install the OWOX Data Marts plugin (Plugins > Install plugin > Sign in). ChatGPT sees the Data Marts it may use, asks, and the answer comes from analyst-written SQL.
- Business questions, answered from trusted data.
ChatGPTWhere did our ad spend go this week, by channel?get_relevant_data_marts_by_promptquery_data_martplatform_roasplatform_cpaKeep ChatGPT 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 AWS Athena and ChatGPT
OWOX keeps AWS Athena for storage and puts governed Data Marts between it and ChatGPT, 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 answer ChatGPT gives from it shows the same numbers.
- Answers you can trace. ChatGPT queries only the Data Marts you expose, and every answer traces back to the SQL behind it.
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.