Amazon Redshift destination for ELT & CDC

Overview

Integrate.io uses the COPY query to sync data from S3 to Redshift using UPSERTS in periodic batches. The data stored temporarily in S3 is removed after it has been synced to Redshift.

Requirements

SUPERUSER privileges to create sync user and create schema if not exists.

Create sync user

Let’s start by creating a sync user for Integrate.io ELT & CDC. Run the following query,

CREATE USER flydata PASSWORD '<your_password>';

Grant database privileges

The sync user needs CREATE and TEMPORARY privileges to create the schema and temporary tables. Specify the database that you’d like the data to be synced to and run the following query to grant the privileges to the user on that database,

GRANT CREATE ON DATABASE <database_name> TO flydata;
GRANT TEMPORARY ON DATABASE <database_name> TO flydata;

Grant schema privileges

The sync user needs USAGE and CREATE privileges to create the tables in the schema. Specify the schema that you’d like the data to be synced to and run the following query to grant the privileges to the user on that schema,

CREATE SCHEMA IF NOT EXISTS <schema_name>;
GRANT USAGE ON SCHEMA <schema_name> TO flydata;
GRANT CREATE ON SCHEMA <schema_name> TO flydata;

Note:If you want to store your logs in your own S3 bucket when syncing from your source to redshift, refer to this guide.

Required Privileges

Name	Description	Enforced?	Reference
CREATE (Database)	For databases, CREATE allows users to create schemas within the database. Required for creating database if it doesn’t exist.	✅	https://docs.aws.amazon.com/redshift/latest/dg/r_GRANT.html
TEMPORARY (Database)	Grants the permission to create temporary tables in the specified database. Required for deduplication.	✅	https://docs.aws.amazon.com/redshift/latest/dg/r_GRANT.html
CREATE (Schema)	For schemas, CREATE allows users to create objects within a schema. To rename an object, the user must have the CREATE permission and own the object to be renamed. Required for creating schema if it doesn’t exist.	✅	https://docs.aws.amazon.com/redshift/latest/dg/r_GRANT.html
USAGE (Schema)	Grants USAGE permission on a specific schema, which makes objects in that schema accessible to users. Required for replication.	✅	https://docs.aws.amazon.com/redshift/latest/dg/r_GRANT.html

Configure S3 Bucket for Redshift

Data Type Mapping - Redshift

IP Allowlist

Initial Sync Process

Last modified on May 12, 2026

ELT/CDC: Destinations

ELT/CDC: Configure S3 bucket for Redshift sync

⌘I

Getting Started

Pipelines

Sources

Destinations

Monitoring

Security

Transforms

Data Observability

Amazon Redshift destination for ELT & CDC

Overview

Requirements

Create sync user

Grant database privileges

Grant schema privileges

Required Privileges

Configure S3 Bucket for Redshift

Data Type Mapping - Redshift

IP Allowlist

Initial Sync Process

​Overview

​Requirements

​Create sync user

​Grant database privileges

​Grant schema privileges

​Required Privileges

​Related

Configure S3 Bucket for Redshift

Data Type Mapping - Redshift

IP Allowlist

Initial Sync Process

Overview

Requirements

Create sync user

Grant database privileges

Grant schema privileges

Required Privileges

Related