Redshift Setup Guide In Dev

Follow our setup guide to replicate your Redshift database to your destination using Fivetran.

Prerequisites

To connect Redshift to Fivetran, you need the following:

Access to the AWS console
A Redshift cluster
SELECT access granted for the following tables:
- PG_CLASS
- PG_NAMESPACE
- PG_DATABASE
- PG_CONSTRAINT
- SVV_ALL_COLUMNS

Setup instructions

Choose connection method

Decide how you want to connect your database to Fivetran. How you configure your security groups in later steps will differ depending on this decision.

Connect directly

If you connect directly, create a rule in a security group that allows Fivetran access to your Redshift instance and port.

Connect using private networking

AWS PrivateLink allows VPCs and AWS-hosted or on-premises services to communicate with one another without exposing traffic to the public internet. PrivateLink is the most secure connection method. Learn more in AWS’ PrivateLink documentation.

Configure your firewall and/or other access control systems to allow incoming connections to your host and port from Fivetran's IPs for your region.

Finish Fivetran configuration

In your connector setup form, enter a destination schema prefix. This prefix applies to each replicated schema and cannot be changed once your connector is created.
Enter the Redshift cluster Host name.
In the Port field, enter the port number for the corresponding host name.
Enter the corresponding Database name.
Enter the User name for the Redshift cluster.
Choose the Authentication Type: PASSWORD. The default type is PASSWORD.
Choose a Connection method: DIRECTLY or PRIVATE NETWORKING.
Click Save and Test. Your Redshift connector is now connected.

Setup tests

Fivetran performs the following Redshift connection tests:

The Database Host Connection Test validates the database credentials you provided in the setup form. The test verifies that the host is not private and then checks the connectivity to the host.
The Redshift Connection Test connects to your database instance and queries for the version.
The Redshift Permission Test checks whether you have SELECT access to the following tables: pg_class, pg_namespace, pg_database, stv_tbl_perm.

NOTE: The tests may take a couple of minutes to finish running.

Connector Overview

Schema Information

API Connector Configuration