# 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

1. Query live data in Redshift without exporting it or standing up a new pipeline
2. Keep dashboards and dbt models in sync with Redshift instead of a stale nightly copy
3. Give 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.

- staging/stg_redshift.sql
- semantic/redshift_metrics.yml

## How it works

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.

- `$ /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.

- `$ /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.

- `$ /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.

- `$ /dex:maintain`

## Other warehouses

Dex brings the same loop and the same guardrails to each of these:

-  [BigQuery](/content/connectors/bigquery/index.html)
-  [Snowflake](/content/connectors/snowflake/index.html)
-  [Databricks](/content/connectors/databricks/index.html)
-  [ClickHouse](/content/connectors/clickhouse/index.html)
-  [PostgreSQL](/content/connectors/postgresql/index.html)
-  [Trino](/content/connectors/trino/index.html)
-  [DuckDB](/content/connectors/duckdb/index.html)

## Need a connector we don't support yet?

Tell us about your data source and we'll let you know as soon as the connector is available.
