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

# Redshift

> Amazon Redshift is a fully managed, petabyte-scale data warehouse service in the cloud. Evidence supports connecting to Redshift as a data source, allowing you to query data using SQL. The format of the connection string is: `redshift://<USER>:<PASSWORD>@<HOST>:<PORT>/<DATABASE>?sslmode=require&options=-csearch_path%3D<SCHEMA>`.

## Add New Connection

To add a Redshift data source, first create a new connection:

1. Select the [Connectors](https://evidence.studio/connectors) item in the left sidebar.
2. In the connection types section, select the Redshift connector from the list.
3. Fill in the connection details and click the "Create" button.
4. Once the connection is created, you can add tables as sources to use in your Evidence project.

## Connection Methods

Evidence supports the following connection methods for Redshift:

* [Connection URI](#connection-uri)

### Connection URI

#### Options

<ResponseField name="Connection String" type="text" required />

<ResponseField name="Schema" type="text">
  Defaults to public if not specified
</ResponseField>

## Connection String Format

```
redshift://<USER>:<PASSWORD>@<HOST>:<PORT>/<DATABASE>?sslmode=require&options=-csearch_path%3D<SCHEMA>
```

The `sslmode` option can be one of:

```
disable, allow, prefer, require, verify-ca, verify-full
```