Redshift
Write data to an Amazon Redshift table using staging tables and MERGE. Use SignalSmith 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 SignalSmith and the Redshift cluster endpoint
Authentication
Redshift uses Username & Password authentication.
- Enter the Redshift Username and Password in SignalSmith
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 — SignalSmith reads column metadata from Redshift’s information_schema
How It Works
SignalSmith uses staging tables and MERGE for efficient bulk operations:
- Data is loaded into a temporary staging table
- A MERGE statement is executed against the target table
- 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 SignalSmith.
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.