Amazon Redshift
This page describes how to sync data to your Redshift data warehouse.
Last updated
Was this helpful?
This page describes how to sync data to your Redshift data warehouse.
Last updated
Was this helpful?
This guide will walk you through connecting to AWS Redshift as a destination.
Visit the and click + New Destination.
Select Redshift from the menu.
Enter the requested database credentials:
Hostname
Host name or IP address of database
Port
Port of database (5439 by default for Redshift)
Database Name
Name of database within Redshift to connect to
Username
Username Census will use to connect
Password
Password Census will use to connect
Number of Client Connections
Value between 1 and 8 (default is 1). This is the maximum number of concurrent connections Census will use to connect to database. The default should be fine in most cases, but increasing this value can increase throughput on very large syncs.
To use Redshift as a destination, Census requires permission to write to the desired destination tables, as well as read metadata about the table and database structures.
Object Name
Supported?
Sync Keys
Behaviors
Table
✅
Primary Keys or Columns with Uniqueness Constraints
Update or Create, Update Only, Add
Census can successfully connect to Redshift instances that are using advanced networking controls including region constraints and IP address allow lists. For more information, see our Network Access Controls documentation.
Learn more about all of our sync behaviors in our documentation.
if you want Census to support more Redshift objects and/or behaviors.
via support@getcensus.com or start a conversation with us via the chat.