Back to integrations
Amazon Redshift
Fully-managed data warehouse service in the cloud for analytics and BI.
Warehouse
How nao works with Amazon Redshift
nao connects directly to Amazon Redshift and reads your full schema on every sync, keeping the analytics agent aligned with your tables and columns. If you use dbt on Redshift, nao ingests your manifest automatically and turns model documentation, lineage, and metric definitions into agent context with no manual re-documentation.
Queries run in your own Redshift cluster using your credentials. Business users ask questions in plain English from the nao Chat UI, Slack, or Teams, and nao generates the SQL, executes it, and returns the answer with the query and source tables shown for full transparency.
What you can do with nao and Amazon Redshift
- Let business users query Redshift in plain English without waiting on the data team
- Import dbt-on-Redshift documentation and lineage as agent context automatically
- Run nao's evaluation framework on your Redshift question set before deploying to end users
- Surface generated SQL and audit logs for every query the agent runs against Redshift
