Amazon Redshift

Amazon Redshift is a fully managed, reliable data warehouse service in the cloud that offers large-scale storage and analysis of data set and performs large-scale database migrations. It is a part of the larger cloud-computing platform Amazon Web Services (AWS).

You can ingest data from your Amazon Redshift database using Hevo Pipelines and replicate it to a Destination of your choice.


Object Settings

Object settings must be configured if the Ingestion mode is Table.

To do this:

  1. Once the Source settings are specified in step 4, select the objects to be replicated in the SELECT OBJECTS YOU WANT TO REPLICATE page, and then, click CONTINUE.

    Select objects

    Note: Each object represents a table in your database.

  2. In the CONFIGURE SOURCE OBJECTS page, specify the query mode to be used for each selected object.


Limitations

None.


See Also


Revision History

Refer to the following table for the list of key updates made to this page:

Date Release Description of Change
Apr-21-2022 1.86 Updated section, Configure Amazon Redshift Connection Settings.
Jan-24-2021 NA Updated section, Whitelist Hevo’s IP Addresses as per the latest Amazon Redshift interface.
Jan-03-2022 1.79 Updated the description of the Include New Tables in the Pipeline advance setting in the Configure Amazon Redshift Connection Settings section.
Jul-26-2021 1.68 Added a note for the Database Cluster Identifier field.
Jul-12-2021 1.67 Added the field Include New Tables in the Pipeline under Source configuration settings.
Feb-22-2021 1.57 Revised the document to include the end-to-end procedure for configuring Amazon Redshift as a Source.
Last updated on 15 Nov 2022

Tell us what went wrong