Redshift Setup Guide Private Previewlink
Follow our setup guide to replicate your Redshift database to your destination using Fivetran.
Prerequisiteslink
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
STV_TBL_PERM
Setup instructionslink
Choose connection methodlink
Connect directlylink
If you connect directly, create a rule in a security group that allows Fivetran access to your Redshift instance and port.
Connect using private networkinglink
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 configurationlink
- 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 testslink
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.
Related articleslink
description Connector Overview
account_tree Schema Information
settings API Connector Configuration