Move Redshift data anywhere it matters.

Send Redshift data to any warehouse, lake or AI app.

Sync Redshift free Read the docs

Source

Redshift

Snowflake
BigQuery
Postgres
Databricks
Claude

Destinations: 50+
Standard support: 0.5.5

Overview

What is the Airbyte Redshift connector?

The Airbyte Redshift connector extracts data from Redshift and loads it into 50+ destinations such as Snowflake, BigQuery, Databricks or Postgres, with full refresh and incremental sync. It publishes tables and events you can select per connection.

01
Sync to your warehouse
Land Redshift data in 50+ destinations on a schedule you control.
02
Incremental syncs
Pull only the records that changed since the last run instead of reloading everything.
03
One authorization
Authenticate Redshift once and Airbyte keeps every scheduled sync running on it.
04
Cloud or self-hosted
Run the Redshift connector on Cloud, OSS, Hybrid.

Setup

Live in ten steps

Open the Airbyte UI and navigate to the "Sources" tab.
Click on the "Create a new connection" button and select "Redshift" as the source.
Enter a name for the connection and click "Next".
Enter the necessary credentials for your Redshift database, including the host, port, database name, username, and password.
Test the connection to ensure that the credentials are correct and the connection is successful.
Select the tables or views that you want to replicate from Redshift to Airbyte.
Choose the replication method, either full or incremental, and set any necessary parameters.
Click "Create connection" to save the configuration and start the replication process.
Monitor the replication progress and troubleshoot any errors that may occur.
Once the replication is complete, you can use the data in Airbyte for further analysis or integration with other tools.

Configuration fields

Redshift configuration fields
Field	Type	Description
database*	string	Name of the database.
host*	string	Host Endpoint of the Redshift Cluster (must include the cluster-id, region and end with.redshift.amazonaws.com).
password*	string	Password associated with the username.
port*	integer	Port of the database.
username*	string	Username to use to access the database.
jdbc_url_params	string	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).
schemas	array	The list of schemas to sync from. Specify one or more explicitly or keep empty to process all schemas. Schema names are case sensitive.

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 sync from Redshift with Airbyte?

The Redshift connector syncs the tables and events published in Airbyte docs.

Does the Redshift connector support incremental sync?

Yes. The Redshift connector supports incremental sync on selected streams, and full refresh on every stream.

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