Open navigation

About Redshift prerequisites

To start using Redshift as a Supermetrics destination, some requirements need to be met. These prerequisites ensure that a working connection can be set up to successfully transfer data to your Redshift data warehouse.


Database and schema

You need a Redshift cluster, database, and schema in place before you can create a Redshift destination for Supermetrics. Learn more about Redshift in its documentation.


You'll need a Redshift user with permissions CREATE and USAGE on the schema you want to send data to, and the password corresponding to that user.

Your Redshift cluster admin or superusers can run the needed SQL queries to create or alter users and grant the needed permissions.

IP allowlisting

You’ll need to allowlist select IP addresses if your organization only allows access from “selected networks”. Add the IP addresses listed here to your cluster’s Inbound Rules in its VPC security group. Don’t forget to include your own IP address.

Navigate to Clusters → Properties → Network and security settings → listed VPC security group → Edit Inbound Rules to add the IP addresses. Don't forget to include your organization's own.

<Your organization's IP address>

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.