Amazon Redshift
This page describes how to sync data to your Redshift data warehouse.
๐โโ๏ธ Getting Started
This guide will walk you through connecting to AWS Redshift as a destination.
If you are trying to use Redshift as a data source (to query data from Redshift and sync to elsewhere), that process is documented separately here: Redshift Data Source
Visit the Destinations page and click + New Destination.
Select Redshift from the menu.
Enter the requested database credentials:
Credential | Description |
---|---|
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. |
๐ Permissions
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.
๐ Supported Objects and Behaviors
Object Name | Supported? | Sync Keys | Behaviors |
Table | โ | Primary keys or columns with uniqueness constraints | Update or Create, Update Only, Append |
Contact us if you want Census to support more Redshift objects and/or behaviors.
๐ฆAdvanced Network Configuration
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.
๐ Need help connecting to Redshift?
Contact us via support@getcensus.com or start a conversation with us via the in-app chat.
Last updated