How to connect Amazon Redshift to an AI data analyst
Updated 2026-07-01
An AI data analyst is most useful when it runs on your real data. This guide shows how to connect Amazon Redshift so you can ask questions in plain English and get charts, dashboards and reports back — without writing SQL by hand.
The setup takes a few minutes: connect with a read-only user, let the analyst read the schema, and ask your first question. Your credentials are encrypted, and the analysis runs on your own AI provider key.
- 1
Get your Amazon Redshift connection details
You need the cluster endpoint, port (usually 5439), database name, username and password. Copy the endpoint from the Redshift console.
- 2
Create a read-only user (recommended)
Create a read-only user and GRANT SELECT on the schemas you want the analyst to see. Keep it separate from any ETL user.
- 3
Create your account and add your AI key
Sign up, then add your own AI provider key (bring-your-own-key). If you don't have one yet, a free key takes about a minute to create — your key is encrypted and used only for your requests.
- 4
Add the Amazon Redshift connection
Add a data source, choose Redshift, and enter the endpoint, port, database, user and password. Redshift requires SSL, so keep it enabled, then test and save.
- 5
Let the AI read and annotate your schema
The analyst annotates your Redshift tables and columns. If you build models with dbt, point it at that schema so it understands your warehouse layout.
- 6
Ask your first question in plain English
Ask something like "Daily active users over the last 90 days". On complex questions the analyst shows a readable query plan before it runs anything; review it, then get a chart plus the data behind it. Refine by chatting, then pin it to a dashboard or save it as a report.
Why connect Amazon Redshift instead of exporting
A static export goes stale the moment you download it, and a general AI assistant that only sees a pasted file guesses what your columns mean. A connected AI data analyst reads live Amazon Redshift data, shows the query plan before running it, and remembers what your fields mean between sessions — so answers stay current and consistent.
Amazon Redshift: things to know
- Make sure the cluster's security group allows inbound access from the app.
- Redshift is a warehouse — ask for a date range on large fact tables to keep answers fast.
Example questions to ask your Amazon Redshift data
- Daily active users over the last 90 days
- Gross margin by product category this year
- Funnel conversion by acquisition channel
Keeping it safe
- Connect with a read-only user so the analyst can never change your data.
- A read-only SQL guard blocks anything that isn't a read query.
- Connection details and your AI key are encrypted at rest.
- Your business data isn't stored or used to train any model.
Frequently asked questions
Related
Get your end-to-end AI business intelligence now.
Conversational analytics with AI that understands your data — no SQL, no data team required.