Connect Redshift data with any data source.

Send data from every Airbyte source to Redshift.

Load data into Redshift Read the docs

Sources: 590+
Certified support: 4.0.12

Overview

What is the Airbyte Redshift connector?

The Airbyte Redshift connector loads data from 590+ Airbyte sources into Redshift, with full refresh and incremental sync on a schedule you control.

01
Load from any source
Move data into Redshift from 590+ Airbyte sources on a schedule you control.
02
Incremental syncs
Pull only the records that changed since the last run instead of reloading everything.
03
Cloud or self-hosted
Run the Redshift connector on Cloud, OSS, Hybrid.

Setup

Live in ten steps

First, log in to your Airbyte account and navigate to the "Destinations" tab on the left-hand side of the screen.
Click on the "Add Destination" button and select "Redshift" from the list of available connectors.
Enter your Redshift database credentials, including the host, port, database name, username, and password.
Choose the schema you want to use for your data in Redshift.
Select the tables you want to sync from your source connector to Redshift.
Map the fields from your source connector to the corresponding fields in Redshift.
Choose the sync mode you want to use, either "append" or "replace."
Set up any additional options or filters you want to use for your sync.
Test your connection to ensure that your data is syncing correctly.
Once you are satisfied with your settings, save your configuration and start your sync.

Configuration fields

Redshift configuration fields
Field	Type	Description
database*	string	Enter the name of the database you want to sync data into
host*	string	Enter your Redshift Cluster Endpoint (must include the cluster-id, region and end with.redshift.amazonaws.com)
password*	string	Enter the password associated with the username.
port*	integer	Enter your Database Port
schema*	string	Enter the name of the default schema tables are written to if the source does not specify a namespace. Unless specifically configured, the usual value for this field is "public".
username*	string	Enter the name of the user you want to use to access the database
drop_cascade	boolean	WARNING! This will delete all data in all dependent objects (views, etc.) including during schema evolution of columns. Use with caution. This option is intended for usecases which can easily rebuild the dependent objects.
jdbc_url_params	string	Enter the additional properties to pass to the JDBC URL string when connecting to the database (formatted as key=value pairs separated by the symbol &). Example: key1=value1&key2=value2&key3=value3

Hybrid deployment

Sovereign by architecture, not by policy.

The data plane runs in your environment. Records, credentials and keys stay with you; the control plane only receives configuration and job metadata.

Cloud
OSS
Hybrid

Your environment

DataConnectorsCredentialsKeys

↕ metadata only

Airbyte control plane

OrchestrationMonitoringUI

FAQ

Redshift connector questions

What data can I load into Redshift with Airbyte?

Airbyte moves data from any supported source into Redshift on a schedule you control, with full refresh and incremental sync where the destination supports it.

Does the Redshift connector support incremental sync?

Yes. The Redshift destination supports full refresh and incremental sync, so Airbyte can load only the records that changed since the last sync.

Where can I run the Redshift connector?

Run the Redshift connector on Cloud, OSS, Hybrid. Hybrid deployments keep the data plane in your environment while the control plane orchestrates syncs.

Didn't find your answer? Talk to sales