Redshift

AWS Redshift data warehouse. Dex profiles your schemas and authors dbt models directly.

Why connect Redshift?

Connecting Redshift means your team stops exporting it by hand and starts working with it directly inside Dex.

What you get

1Query live data in Redshift without exporting it or standing up a new pipeline
2Keep dashboards and dbt models in sync with Redshift instead of a stale nightly copy
3Give teams governed, self-serve access to Redshift under the same RBAC and audit trail as everything else

In your repositoryDex

Agent-native analytics engineering for your dbt project.

Explore, transform, maintain: the Dex loop on Redshift.

1
Point Dex at Redshift
Install Dex in Claude Code by running /plugin marketplace add exmergo/exmergo-agent-plugins and /plugin install dex@exmergo, then run /dex:explore against Redshift. Dex connects with your Redshift credentials directly, so they, and your raw data, never enter the model's context.
redshift
- /plugin marketplace add exmergo/exmergo-agent-plugins
- /plugin install dex@exmergo
- /dex:explore
2
Explore before touching anything
/dex:explore profiles the schema it finds in Redshift and proposes what to model before writing a single line of dbt.
redshift
- /dex:explore
3
Author governed dbt models
/dex:transform writes and maintains the dbt models and tests that turn raw Redshift data into trusted, reusable tables in your project.
redshift
- /dex:transform
4
Stay inside a cost guard
Dex enforces a cost guard on every query it runs against Redshift, so exploration never turns into a surprise bill.
5
Catch drift automatically
/dex:maintain flags it when Redshift's schema changes and proposes the fix, instead of letting your dbt project silently drift out of sync.
redshift
- /dex:maintain