To authenticate with Redshift you'll first need to set up security credentials.

Either create a new api user (recommended), or use your own account.

The user must have the following IAM permissions:

Once that's done, go to security credentials and go to access keys.

Create and copy the access key and the secret key.
​
Next, go to the Amazon Redshift integration page by clicking here.

Click authenticate and fill in your access key, secret key, and aws region.

Your region is the first part of your aws url. For example, if your url is us-west-1.console.aws.amazon.com, then your region is us-west-1
​
Then click authenticate again.

You're now authenticated with Amazon Redshift! 🎉

Simplesat can automatically sync feedback to Amazon Redshift.
​

Here's an example of how this will look in Redshift:
​

To set this up, visit the Redshift integration page by clicking here.
​
Scroll down to sync feedback data to Amazon Redshift and click activate integration.

Once it's successfully activated, deactivate the integration, scroll down to variables.

If you're on Redshift serverless then fill in your workgroup name.

If you're on Redshift provisioned then fill in your cluster identifier and your database user.

Optionally, set the database and table name where you would like your feedback synced to.

Then click save and activate the integration.

The first time you'll receive new feedback a new table will be created and all your historical feedback will be imported into there.

Afterwards, any new feedback will be appended to that table, and updated feedback will update the existing feedback into the table.
​
​
​