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

# Redshift

> Connect your Redshift data warehouse to Seam

## Prerequisites

<Warning>
  **Firewall Configuration Required**

  If your database is behind a firewall, you must allow connections from the following Seam IP addresses:

  * 34.171.4.17
  * 54.190.82.25
  * 44.232.40.21
  * 35.155.106.54
  * 54.200.67.134
  * 44.224.213.129
  * 54.149.95.139
</Warning>

## Configuration Steps

### 1. Create a Seam User in Redshift

You'll need to create a dedicated read-only user for Seam to access your Redshift cluster. You can run these commands using:

* A SQL client connected to Redshift with admin credentials
* The AWS console's Redshift query editor

#### SQL Commands

Replace the following placeholders in the commands below:

* `<schema>` - The name of your Redshift schema
* `<table>` - The name of your Redshift table (if using Option 2)
* `<password>` - A randomly generated password (save this for later)

```sql theme={null}
-- Create a new user for Seam
CREATE USER seam_integration_user WITH PASSWORD '<password>';

-- Grant access to the schema (always required)
GRANT USAGE ON SCHEMA <schema> TO seam_integration_user;

-- Option 1: Grant read-access to all tables in the schema
GRANT SELECT ON ALL TABLES IN SCHEMA <schema> TO seam_integration_user;

-- Option 2: Grant access to specific tables (repeat as necessary)
GRANT SELECT ON TABLE <schema>.<table> TO seam_integration_user;
```

<Note>
  You can modify the `GRANT` statements to limit the scope of Seam's permissions. Choose Option 1 to grant access to all tables in a schema, or Option 2 to grant access only to specific tables.
</Note>

### 2. Gather Connection Details

Navigate to the AWS console and locate your Redshift cluster information:

**AWS Console Path:** Redshift → Clusters → `[your-cluster-name]` → Properties

<Frame>
  <img src="https://mintcdn.com/signal-97/BCdd6viqBQJrcsML/assets/images/redshift.png?fit=max&auto=format&n=BCdd6viqBQJrcsML&q=85&s=cde42076f4be68a7c347db7f2a9aae0c" alt="BigQuery Project ID location" width="1552" height="646" data-path="assets/images/redshift.png" />
</Frame>

You'll need the following information to complete the Seam connection:

<ParamField path="endpoint" type="string" required>
  Redshift Cluster Endpoint
</ParamField>

<ParamField path="username" type="string" required>
  The username you created (e.g., `seam_integration_user`)
</ParamField>

<ParamField path="password" type="string" required>
  The password you set for the Seam user
</ParamField>

<ParamField path="database" type="string" required>
  Database name
</ParamField>

<ParamField path="port" type="number" default="5439">
  Port (default: 5439)
</ParamField>