Redshift
Write data to an Amazon Redshift table using staging tables and MERGE. Use Zeotap to materialize model results or enriched data into Redshift.
Prerequisites
- An Amazon Redshift cluster or Redshift Serverless workgroup
- A database user with CREATE TABLE, INSERT, UPDATE, and DELETE privileges
- Network connectivity between Zeotap and the Redshift cluster endpoint
Authentication
Redshift uses Username & Password authentication.
- Enter the Redshift Username and Password in Zeotap
Configuration
| Field | Type | Required | Description |
|---|---|---|---|
| Host | Text | Yes | Redshift cluster endpoint hostname (e.g., my-cluster.abc123.us-east-1.redshift.amazonaws.com) |
| Port | Number | No | Server port. Default: 5439 |
| Database | Text | Yes | Database name (e.g., dev) |
| SSL Mode | Select | No | SSL mode: Require, Verify CA, or Disable. Default: Require |
Target Settings
| Field | Type | Required | Description |
|---|---|---|---|
| Schema | Text | Yes | Database schema to write to. Default: public |
| Table | Text | Yes | Target table name |
Supported Operations
Sync Modes: Upsert, Insert, Update, Mirror
Audience Sync Modes: Add, Remove, Mirror, Upsert
Features
- Field Mapping: Yes
- Schema Introspection: Yes — Zeotap reads column metadata from Redshift’s information_schema
How It Works
Zeotap uses staging tables for efficient bulk operations:
- Data is loaded into a temporary staging table
- For upserts, existing matching rows are deleted, then new/updated rows are inserted from staging
- For updates, an UPDATE … FROM pattern is used to apply changes
- The staging table is dropped after the sync
Troubleshooting
Connection failed
Verify the cluster endpoint, port, and database name. Ensure the Redshift cluster is publicly accessible or that the network allows connections from Zeotap.
Insufficient privileges
The user needs USAGE on the schema, and CREATE, INSERT, UPDATE, DELETE privileges on tables.
Cluster paused
If the Redshift cluster is paused, it must be resumed before syncs can run. Redshift Serverless workgroups resume automatically.
SSL required
Amazon Redshift typically requires SSL. Set SSL Mode to Require or Verify CA.