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

# Redshift

<Warning> Only an admin can set up the Redshift integration. </Warning>

Connecting Soal to your Redshift instance allows users to run sql queries in [notebooks](/essentials/notebooks) and allows Soal to [suggest queries](/essentials/generated_queries) using AI.

### Step 1. Create the warehouse connection

* Log in to your Redshift data warehouse at [http://console.aws.amazon.com/redshiftv2/home](http://console.aws.amazon.com/redshiftv2/home)

* Create a user with read permissions to the schema and tables that you want to connect from.

* If data will be written back to the warehouse from Soal, add a schema and permissions to allow the Push.ai user to write to a specific schema.

### Step 2. Whitelist Soal's IP Addresses

Soal will connect to your database from the following IP addresses. Please make sure to allow traffic from these IPs:

* `00.000.000.000`

### Step 3. Configure the connection in Soal

* Add the Host, Port, Database, Username, Password

* Click Test Redshift to confirm the connection settings.

* Click Connect Redshift to complete the connection.