Amazon Redshift

Configure in Redshift

1. For Quest to integrate with Amazon Redshift, create a user and password via the CREATE USER command in Amazon Redshift that Quest Data can use to connect:

   create user simondata password '<password here>'

2. Grant Quest 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 Quest

Configure in Quest

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.