Home

Amazon Redshift

ConnectyAI allows you to connect to Amazon Redshift instance via one of the following methods:

  1. Using Direct Connection.

  2. Connecting via an SSH Tunnel.

  3. Using Redshift Data API.

Prerequisites

Before you begin please, make sure you have the following:

  • Your Amazon Redshift host (endpoint), port, database name and user credentials.

  • Network configuration that allows ConnectyAI, to reach your Amazon Redshift instance. That may require configuring an AWS Security Group and/or your firewall.

  • In case of using an SSH Tunnel, credentials for bastion host.

  • In case of using Redshift Data API, service account IAM user CLI credentials and apprioprate IAM role.

ConnectyAI IPs

52.2.141.187
34.224.181.184
54.243.108.40
18.193.219.122

Direct Connection

In Direct Connection approach ConnectyAI needs to have direct network access to your Amazon Redshift instance. That usually means:

  • Your Amazon Redshift instance should have public access property turned on.

  • The Security Group attached to your Amazon Redshift instance should allow incoming traffic from ConnectyAI IPsaddresses on the port configured for your instance.

Once the network connection can be established, then you need to configure the following fields.

1. Host and Port

Your Amazon Redshift instance host is the URL pointing to that instance. It's usually of the form:

  • ✅ Host: <instance-name>.<aws-account-id>.redshift-serverless.amazonaws.com

  • ❌ Host: <instance-name>.<aws-account-id>.redshift-serverless.amazonaws.com:5439/db (do not include database or port in the host)

  • ✅ Port: 5439 (default port)

2. Username and Password

These credentials authenticate you to the database.

  • Username: the database user name.

  • Password: the password associated with that user.

3. Database name

Connection needs to be established for a given database. Please make sure that given database exists in given Amazon Redshift instance and the configured user has appropriate access.

4. SSL Mode (optional)

Controls whether and how SSL/TLS is used for the connection. Available options:

  • require : SSL is required, but the server certificate is not verified.

  • verify-ca : SSL required and server certificate must be signed by a trusted CA.

  • verify-full : SSL required and server hostname must match certificate.

Default value in ConnectyAI connections is require. For verify-ca and verify-full options please contact our support.

SSH Tunnel

Available on the Enterprise Plan.

Redshift Data API

Available on the Enterprise Plan.

Last updated