Connector Catalog
Sources
Redshift

The Redshift source supports Full Refresh syncs. That is, every time a sync is run, Airbyte will copy all rows in the tables and columns you set up for replication into the destination in a new table.
This Redshift source connector is built on top of the source-jdbc code base and is configured to rely on JDBC 4.2 standard drivers provided by Amazon via Mulesoft here as described in Redshift documentation here.

The Redshift source does not alter the schema present in your warehouse. Depending on the destination connected to this source, however, the schema may be altered. See the destination's documentation for more details.

Feature
Supported
Notes
Full Refresh Sync
Yes
Incremental Sync
Coming soon
Replicate Incremental Deletes
Coming soon
Logical Replication (WAL)
Coming soon
SSL Support
Yes
SSH Tunnel Connection
Coming soon
Namespaces
Yes
Enabled by default
Schema Selection
Yes
Multiple schemas may be used at one time. Keep empty to process all of existing schemas

Incremental sync (copying only the data that has changed) for this source is coming soon.

  1. 1.
    Active Redshift cluster
  2. 2.
    Allow connections from Airbyte to your Redshift cluster (if they exist in separate VPCs)

This is dependent on your networking setup. The easiest way to verify if Airbyte is able to connect to your Redshift cluster is via the check connection tool in the UI. You can check AWS Redshift documentation with a tutorial on how to properly configure your cluster's access here

Next is to provide the necessary information on how to connect to your cluster such as the host whcih is part of the connection string or Endpoint accessible here without the port and database name (it typically includes the cluster-id, region and end with .redshift.amazonaws.com).

All Redshift connections are encrypted using SSL

Version
Date
Pull Request
Subject
0.3.9
2022-02-21
9744
List only the tables on which the user has SELECT permissions.
0.3.8
2022-02-14
10256
Add -XX:+ExitOnOutOfMemoryError JVM option
0.3.7
2022-01-26
9721
Added schema selection
0.3.6
2022-01-20
8617
Update connector fields title/description
0.3.5
2021-12-24
8958
Add support for JdbcType.ARRAY
0.3.4
2021-10-21
7234
Allow SSL traffic only
0.3.3
2021-10-12
6965
Added SSL Support
0.3.2
2021-08-13
4699
Added json config validator
Last modified 7mo ago
Copy link
On this page
Overview
Sync overview
Features
Getting started
Requirements
Setup guide
Encryption
Changelog