The Amazon Redshift connector

Note

This connector is based on Airbyte .

You can use this connector for source endpoints.

Source endpoint

  1. Under Host, specify the address of the Amazon Redshift cluster. This string must include the cluster ID, region, and end with .redshift.amazonaws.com.

  2. Enter the Port of the cluster. The default value is 5439.

  3. Specify the name of the Database within the Amazon Redshift cluster.

  4. Under Schemas, specify the names of specific table schemas in the database to transfer. In you don't specify any schemas, Transfer will transfer all tables from the target database.

  5. Enter the Username for your Amazon Redshift cluster.

  6. Enter the Password associated with the username.

To create an Amazon Redshift source endpoint with API, use the endpoint.airbyte.RedshiftSource model.

Airbyte type Transfer type
integer int64
int32
int16
int8
uint64
uint32
uint16
uint8
float
number double
string
time_without_timezone, time_with_timezone, string utf8
boolean boolean
date date
date-time datetime
timestamp, timestamp_with_timezone, timestamp_without_timezone timestamp
object, array, REST... any

See also

In this article: