Setup Guide - Redshift

Follow this setup guide to connect Redshift Data Warehouse to DataChannel.

Prerequisites

  • Have a Redshift Data Warehouse configured and reachable from the DataChannel IPs. Contact support for the list of IP addresses to whitelist incase required.

  • Create a user for DataChannel with SELECT rights on the tables / views you want to pull data from.

  • In case of a heavily utilized production database, it is advisable to connect the read-only replica to pull data from an active Redshift account with permissions to access data from accounts you’d like to sync. This account needs to be a admin account with delete privileges.

Setup instructions

  1. Select a data destination for your Redshift Data. If you have not yet added a data warehouse, go to data warehouse tab and add a warehouse.

    Data Warehouse once selected cannot be changed.

  2. Authorise DataChannel to connect to your Redshift account using the + icon with your Name, DB Host, Username, Password, DB Port, DB Name and DB Schema.

    redshift new creds

  3. Click on + Data Pipeline to start adding data pipelines to your account.

    redshift data source detail

  4. Details of individual objects and reports are available here. .

Still have Questions?

We’ll be happy to help you with any questions you might have! Send us an email at info@datachannel.co.

Subscribe to our Newsletter for latest updates at DataChannel.