# Amazon Redshift

## Configure in Redshift

1. For **Questera AI** to integrate with Amazon Redshift, create a user and password via the [CREATE USER command in Amazon Redshift](https://docs.aws.amazon.com/redshift/latest/gsg/t_adding_redshift_user_cmd.html) that **Questera AI** Data can use to connect:

   `create user simondata password '<password here>'`
2. Grant **Questera AI** select privileges on the appropriate table, schema, or database that we will need to extract from:

   `grant select on <table/schema/db> <name of table/schema/db> to` **Questera AI**

## Configure in Questera AI

1. As an *admin*, expand **Admin Center** then click **Integrations**.
2. Scroll down to **Redshift**.
3. Click **Add**.
4. Enter your **host**, **port**, **database**, **user** (the username you created specific to Simon in Redshift itself), and **password**.
5. Click **Save Changes**

Successful connections display **Connected** in Green.