Enable business reporting from your AWS Redshift data
Turn your data warehouse into a real reporting library. Connected Data Marts, ready for ChatGPT.
AWS RedshiftConnected
ChatGPTDaily 09:00Ask ChatGPT about revenue and it cannot tell which of your AWS Redshift tables holds the right figure.
Paste this into your AI assistant. It connects ChatGPT to your AWS Redshift Data Marts through the OWOX MCP server, so it finds the right Data Mart from its description and answers from its 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-redshift-connector-to-chatgpt.md. The task: connect ChatGPT to my AWS Redshift Data Marts through the OWOX MCP server, point me to the ones that carry revenue, then compare paid media spend and return week on week. 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 Redshift data
Connect OWOX to your Amazon Redshift database, Serverless workgroup or provisioned cluster. Your Data Marts read the tables and views in its schemas.
- Nothing to move or copy.
AWS RedshiftYour data warehouseSchemaBuild a reporting library in AWS Redshift
Each Data Mart is a ready report, described by AI, and joins to other Data Marts through the model.
- Business users browse reports, not tables.
Ask ChatGPT about your AWS Redshift data
Connect the OWOX Data Marts plugin in ChatGPT (Plugins > Install plugin > Sign in). ChatGPT finds the right Data Mart and queries it, and sees only the Data Marts you expose.
- Business questions answered from trusted data.
ChatGPTHow did paid media spend and return compare week on week?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 Redshift to ChatGPT
An assistant is only as good as the data it sees. OWOX gives it governed Data Marts on your AWS Redshift data, not the whole database.
- Yours in AWS. The data stays in your own Redshift database, under your access rules.
- Your access key. OWOX connects with the AWS access key you create, to the workgroup or cluster you choose.
- Governed answers. The assistant queries only the Data Marts you expose, with SQL your analysts wrote.
- An audit trail. See what ChatGPT asked and what it got back.
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.