Skip to main content
Amazon Redshift is a cloud data warehouse. MantrixFlow writes to Redshift using the standard connection fields. Upsert mode uses a staging table and merge pattern because Redshift does not support the same upsert syntax as PostgreSQL.

​
Prerequisites

You need a Redshift cluster and a user with CREATE, INSERT, UPDATE, and DELETE permissions on the target schema.

​
Connection Setup

Enter the Redshift cluster endpoint (host), port (5439), database, username, and password. Ensure the cluster is accessible from the ETL server (security group, VPC).

​
Write Modes

​
Append

Inserts new rows. The table is created if it does not exist.

​
Replace

Drops and recreates the table on every sync.

​
Upsert

Uses a staging table: data is loaded into a staging table, then a MERGE (or DELETE + INSERT) is used to update the target table. Specify the primary key column for the merge.