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.


Prerequisites

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.


Managing schema changes

When you're setting up your schemas, it's important to remember that Supermetrics has the ability to make schema changes to your tables in Redshift. These are generally only triggered by a schema change initiated by you or someone in your Supermetrics team using the Query Manager


To make sure that Redshift is properly equipped to handle these schema changes, ensure that your database follows these guidelines:

  • Don't use views with schema binding
    • By default, Redshift views have schema binding enabled. This means that tables referenced by these views can't be dropped or undergo schema changes. We recommend ensuring that any views that have been created to reference tables created by Supermetrics use the WITH NO SCHEMA BINDING clause in the view definition. Learn more about this in Redshift's documentation on late-binding views.
  • Don't enforce key constraints


Permissions

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 Supermetrics IP addresses 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.


More resources

Did you find it helpful? Yes No

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