> ## Documentation Index
> Fetch the complete documentation index at: https://docs.summation.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Redshift

> Connect Summation to an Amazon Redshift data warehouse.

Summation connects to Amazon Redshift using standard host, port, database, username, and password credentials. After the connection is saved, you can browse Redshift schemas and tables and add them as datasets.

## What you'll need

* A reachable **Redshift endpoint** and **port**. Redshift Serverless defaults to port `5439`. See [Connecting to Amazon Redshift Serverless](https://docs.aws.amazon.com/redshift/latest/mgmt/serverless-connecting.html).
* A **database** name.
* A **user** with access to the schemas and tables you want exposed. The user needs `USAGE` on the schema and `SELECT` on the tables or views. See [GRANT](https://docs.aws.amazon.com/redshift/latest/dg/r_GRANT.html) in the Redshift docs.
* Network access from Summation to your Redshift endpoint.

<Tip>
  Create a dedicated read-only Redshift user for Summation. This keeps queries auditable and prevents accidental writes from the connector.
</Tip>

## Form fields

| Field                     | Required | Stored as | Notes                                                                                 |
| ------------------------- | -------- | --------- | ------------------------------------------------------------------------------------- |
| **Host**                  | Yes      | Config    | Redshift endpoint host, e.g. `cluster.example.us-west-2.redshift.amazonaws.com`.      |
| **Port**                  | Yes      | Config    | Default `5439`.                                                                       |
| **Database**              | Yes      | Config    | Redshift database name.                                                               |
| **Username**              | Yes      | Config    | Login user.                                                                           |
| **Password**              | Yes      | Secret    | Password for the login user.                                                          |
| **SSL Mode**              | Optional | Config    | Default `prefer`. Use `require` or stricter when your Redshift endpoint requires TLS. |
| **Root Certificate Path** | Optional | Config    | Path to a CA bundle when using certificate verification.                              |
| **Connection Pool Size**  | Optional | Config    | Max concurrent connections from Summation. Default `10`.                              |

## Setup SQL

Replace `analytics` with the schema you want Summation to read.

```sql theme={null}
CREATE USER summation PASSWORD '<strong-password>';

GRANT USAGE ON SCHEMA analytics TO summation;
GRANT SELECT ON ALL TABLES IN SCHEMA analytics TO summation;

ALTER DEFAULT PRIVILEGES IN SCHEMA analytics
  GRANT SELECT ON TABLES TO summation;
```

## Adding datasets

After saving the connection, browse Redshift schemas and select tables or views. Source references use the Postgres-compatible form:

```text theme={null}
postgres:public.orders
```

## Common problems

| Error or symptom                   | Likely cause                                                                           |
| ---------------------------------- | -------------------------------------------------------------------------------------- |
| `connection refused`               | Wrong host or port, or your network/firewall doesn't allow traffic from Summation.     |
| `timeout`                          | Redshift is private or behind a VPC path Summation cannot reach.                       |
| `authentication failed`            | Wrong username or password.                                                            |
| `permission denied`                | Grant `USAGE` on the schema and `SELECT` on the table or view.                         |
| Tables don't appear in the browser | The user can connect to the database but lacks access to the schema or table metadata. |