preloader

Add Amazon Redshift data sourceAmazon Redshift

Add your Amazon Redshift account to Scopum as your data source.

Add an Amazon Redshift Data Source to Scopum


To set up your Redshift connection in Scopum, you need to enter your Snowflake details in the Source Settings. This can be done in 5 simple steps.

Step 1: Enter your Redshift connection details
  1. If you aren’t signed into your Scopum account, sign in now.

  2. Select the Connections menu item and click Add Source.

  3. Locate and select the Redshift icon.

Redshift Step 1

  1. Fill in the fields as follows:

    • Name: Choose a name for this Redshift data source. For example ‘My Redshift Data Warehouse’

    • Host (Endpoint): Enter the URL of your Redshift account. Don't include the port number. For example: ‘my-redshift-instance.us-west-2.redshift.amazonaws.com’. Note: Entering the ‘http://' or ‘https://' portion of the URL will prevent a successful connection.

    • Port: Enter the port that is used by your Redshift instance. The default is 5439.

    • Username: Enter the username of your Redshift database user.

    • Password: Enter the password of your Redshift database user.

    • Database: Enter the name of the Redshift database that you want to connect so Scopum.

Redshift example credentials

Step 2: Save the target

When finished, click Check and Continue.

Scopum will perform a connection test to the Redshift database; if successful, a Success! message will display at the top of the screen. If unsuccessful, please double-check the entered Redshift credentials.

Note: This test may take a few minutes to complete.

Step 3: Select Source Table

From the drop-down menu select the database table that you want to get data from.

Step 4: Choose sync type

Depending on the structure and size of your source data, you have two options how to sync your data.

Full sync With every sync run the entire source data set gets synced to your target.

Incremental sync With every sync run only new or changed data gets synced. This requires you to specify a field that is used to determine new and changed data. Most commonly this is a change time-stamp or sequential ID.

Step 5: Finish the Setup

Click Save to finish. You have just completed the setup of Redshift as your data source.

The next step is the setup of an email service provider as your data target.

Subscribe
to our newsletter