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

# Redshift

> Connecting Fabi.ai to your [Redshift](https://aws.amazon.com/redshift/) instance.

<Warning>
  Before connecting, ensure that you whitelist Fabi.ai's IP addresses in your firewall or security group settings:

  * `3.232.60.87`
  * `54.172.255.171`
</Warning>

# Creating a service account user

## 1. Log in to the AWS Management Console

Open the AWS Management Console and navigate to your Redshift cluster.

## 2. Connect to the cluster

Use a SQL client or AWS Query Editor v2 to connect to your Redshift cluster.
Documentation: Connecting to an Amazon Redshift cluster

## 3. Create the service account user

Run the following SQL command to create a new user. Replace service\_account\_user with your desired username and password with a secure password.

```sql theme={null}
CREATE USER service_account_user PASSWORD 'secure_password';
```

* Replace `secure_password` with a strong password.
* Replace `service_account_user` with the service account user name.

## 4. Assign permissions to the user

Fabi.ai needs read access to the schemas you wish to query.

```sql theme={null}
GRANT USAGE ON SCHEMA schema_name TO service_account_user;
GRANT SELECT ON ALL TABLES IN SCHEMA schema_name TO service_account_user;
```

# Connecting Redshift to Fabi.ai

Once you've generated your service user credentials, follow the steps in [Connecting to Your Data](/getting_started/connect_data_sources)
<Tip>For information about our industry-leading security practices, check out our [Security hub](https://www.fabi.ai/security).</Tip>