Amazon Redshift Integration
Connect Amazon Redshift to Edilitics as a source or destination. Step-by-step setup including host, port, credentials, and schema configuration.
Amazon Redshift can be used as both a source and destination in Edilitics. It supports full load, incremental, and CDC (destination only) in Replicate pipelines, and source or destination in Transform flows.
Before You Begin
- Your Redshift cluster endpoint (hostname), port, database name, username, and password.
- The Edilitics IP addresses whitelisted in your Redshift cluster's VPC security group or network access control list:
34.14.190.23434.14.190.234
- Redshift default port: 5439.
Steps to Connect
Step 1: Whitelist Edilitics IP Addresses
In the AWS Console, navigate to your Redshift cluster's security group and add inbound rules to allow TCP traffic on port 5439 from:
34.14.190.234/3234.14.190.234/32
Step 2: Add the Redshift Integration
- In Edilitics, go to the Integrate module.
- Click New Integration.
- Select Amazon Redshift from the integration catalog.
Step 3: Enter Connection Parameters
| Field | Description |
|---|---|
| Host | Your Redshift cluster endpoint (e.g., cluster-name.abc123.us-east-1.redshift.amazonaws.com) |
| Port | Default: 5439 |
| Database Name | The name of the Redshift database to connect |
| Username | Database user with read (and write if using as destination) permissions |
| Password | Password for the database user |
| Schema | Default: public. Change if your tables are in a different schema |
Step 4: Configure the Integration
- Enter an Integration Name.
- Add an optional description.
- Configure AI Column Insights if required. See AI Column Insights.
Step 5: Test and Save
- Click Test Connection to validate credentials and network access.
- On success, click Preview to confirm table access.
- Click Save.
Connection Details
| Field | Value |
|---|---|
| Default Port | 5439 |
| IP whitelisting | Required |
Supported Operations
| Operation | Source | Destination |
|---|---|---|
| Replicate: Full Load | Yes | Yes |
| Replicate: Incremental | Yes | Yes |
| Replicate: CDC | No | Yes |
| Transform | Yes | Yes |
| Visualize | Yes | n/a |
| AskEdi | Yes | n/a |
Need help? Email support@edilitics.com with your workspace, job ID, and context. We reply within one business day.
Last updated on
BigQuery
Connect Google BigQuery to Edilitics as a source or destination. Step-by-step setup for Service Account and User Account authentication.
Snowflake
Connect Snowflake to Edilitics as a source or destination. Step-by-step setup including account identifier, warehouse, database, schema, and credentials.