Amazon Redshift
real-time ingestion
TwinCommit applies changes to Amazon Redshift with exactly-once, commit-ordered semantics from any of 9 log-based sources, including Oracle, MySQL, SQL Server and Db2. S3-staged COPY plus MERGE for a warehouse that mirrors production.
Amazon Redshift
Amazon Redshift provisioned (RA3) and Redshift Serverless
- ✓An S3 staging bucket and IAM role for COPY
- ✓A database user with CREATE on the target schema
- ✓Network path to the cluster or workgroup endpoint
Apply
How TwinCommit writes to Redshift
Micro-batches are written to S3 as Parquet, loaded with COPY into staging tables, and applied with MERGE in one transaction together with the checkpoint.
Redshift target docs →Redshift connector FAQ
Which Redshift versions does TwinCommit support?
+
Amazon Redshift provisioned (RA3) and Redshift Serverless.
How does TwinCommit write to Redshift?
+
Micro-batches are written to S3 as Parquet, loaded with COPY into staging tables, and applied with MERGE in one transaction together with the checkpoint.
Replicate your first table in five minutes.
Download the free Developer edition, or have one of our replication engineers walk you through a migration plan.