Redshift

You can connect your Redshift warehouse to Neo by providing a few essential details. This guide walks you through every required setting—one step at a time.

Getting Started

To connect Redshift, you’ll need:

  • Redshift host, port, database, and schema

  • One of two authentication methods:

    • Standard Username/Password

    • IAM-based AWS Credentials

Connection Details

Let’s walk through what you need to provide:

1. Name

Pick a unique name for this Redshift source.

This helps you identify the source later if you have multiple Redshift or other database connections.

Example:

  • prod-redshift-west

  • team-finance-redshift

The name must be unique for each source you add.

2. Host

Enter the hostname of your Redshift cluster.

It usually looks like:

redshift-cluster-1.abc123xyz.us-west-2.redshift.amazonaws.com

3. Port

Redshift uses port 5439 by default.

Change this only if your Redshift cluster uses a different port.

4. Database

Provide the name of the Redshift database you want to connect to.

Example: analytics_db

5. Schema

Specify the schema inside your database that contains your data.

Example: public, sales, marketing_data

6. Connection Timeout (Optional)

This is the time (in seconds) that the system will wait while trying to connect before giving up.

If you’re unsure, stick with the default: 60 seconds.

Choose Your Authentication Method

You can authenticate using either:

  • Standard username & password

  • AWS IAM credentials

Let’s go over both:

Option 1: Standard Authentication

Use this if you have a regular Redshift user and password.

You’ll need:

User:

Your Redshift username.

Example: readonly_user

Password:

The password for that user.

This will be securely hidden in the UI.

Option 2: IAM Credentials (for AWS setups)

Use this if you want to authenticate using AWS IAM. This method is recommended for production environments and provides better access control.

You’ll need:

Cluster ID:

The actual Redshift cluster ID—not the host.

Example: redshift-cluster-1

Region:

The AWS region where your Redshift cluster is hosted.

Example: us-west-2

Access Key ID:

The AWS access key used for IAM role assumption.

Will be securely hidden in the UI.

Secret Access Key:

The corresponding secret key.

Also hidden in the UI for security.

The IAM role will be assumed using these credentials. Make sure the IAM user has permission to do so.

Still have Questions?

We’ll be happy to help you with any questions you might have! Send us an email at info@datachannel.co.

Subscribe to our Newsletter for latest updates at DataChannel.