Data Source - Redshift
  • 03 Mar 2022
  • Dark
    Light
  • PDF

Data Source - Redshift

  • Dark
    Light
  • PDF

Article Summary

Overview

Help page for setting up a data transfer from Amazon Redshift.

Supported Protocol

Data Loader: Embulk
Using the embulk-input-redshift plugin.

Limitations

None.

Settings

Step 1: General Settings

Field Name
Required
Default Value
Description
Redshift Connection ConfigurationYes-From the Redshift Connection Configurations created in advance, select the one with the necessary permissions for this transfer.
If you have not previously created any Connection Configurations, click the Add Connection Configuration button to set up a new one.
Database NameYes-Enter the database name containing the data that you wish to extract.
SchemaYespublicEnter the name of the schema containing the data that you wish to extract.
Click the Load Schema List button to refresh the list of schema names you can use to auto-complete the field.
QueryYes-In this field, write a query to extract the data from Redshift.
You can use custom variables to embed a value that will be dynamically set when the job executes.

Was this article helpful?