Amazon Redshift destination setup

Review this guide to learn how you can set up Redshift destination for a number of supported by Coupler.io data sources.

1. Select Redshift destination

2. Add destination account

Click '+Add Account' and enter your Redshift server and credentials.

> Host - your host on which the Redshift server is running. The value can be a host name, IPv4 address, or IPv6 address.
> Port - specify the port. The default port number is 5439.
> Database - the name of the database to connect to.
> User - user name of the Redshift account to use for connecting to the server. (Make sure the user has needed permissions for the database and table you would like to import data to)

The following permissions are required:

CREATE privilege on the database level

CREATE privilege on the schema level

INSERT privilege on the table, you want to import data into

> Password - corresponding password of the Redshift account used for connecting to the server.

Note: you’ll need to allowlist Coupler.io IP addresses if your organization only allows access from “selected networks” . Those IP addresses are:

34.123.243.115

34.170.96.92

3. Specify a schema & table, where you would like to import data to.

You can type either an existing schema/table name or enter a new one. By typing in a new name that doesn’t exist yet, Coupler.io will create a new schema/table and then import data.

4. Pick the right import mode

Replace - fully replaces all previously imported data with the latest information available in your data source.
Append - places your newly imported data under previously imported entries; is suitable for tracking historical data changes.

For Append mode: if the schema of your data is changed you need to make adjustments in the Redshift table first (e.g. add a new column) and then re-run the importer.

5. Set up an automatic data refresh

5.1. Set up a schedule for data refresh

Specify Interval, Days of the week, Time of the day, and Schedule time zone to run the Automatic data refresh.
Learn more about Automatic data refresh.

5.2. Save the changes

Click SAVE AND RUN to save the parameters and run the initial import right away.