Skip to main content

Connect to Redshift (AWS)

Securely connect your Hex workspace to Redishift (AWS).

info
  • Users need the Admin workspace role to create a shared workspace data connection.
  • Users need Can Edit or higher project permissions to create project data connections.

Redshift is an Amazon Web Services (AWS) cloud data warehouse built for large-scale analytics on structured data. It's a mature, feature-rich platform that integrates deeply with the AWS ecosystem (S3, Glue, QuickSight, etc.) and offers strong price-performance, especially if you're already invested in AWS. Redshift is columnar and optimized for complex analytical queries across petabytes of data, making it an ideal warehouse for intensive analytics workloads, especially if you're already AWS-native.

How to get set up​

  1. Sign in to the AWS Redshift console, or a create an account if you don't have one.
  2. Create an AWS secret access key for the IAM user with appropriate Athena access for your data connection (instructions to generate).
tip

Currently only AWS users who do not use MFA authentication are supported.

  1. In Hex, go to Settings → Data sources.
  2. Click + Connection, select Redshift, and fill out the required fields.

Basic settings​

  1. Name and Description - Set a display name and optional description to help identify your data connection.
  2. Host and Port - The address of your Redshift database, and the port used for secure native connections to your Redshift database. The default port is 5439.
  3. Database - The name of the Redshift database you're connecting to.
  4. Authentication type - Choose your authentication type (Password or Certificate) and fill out the required fields.
Redshift data connection form

Additional settings​

The data connection form includes several optional sections:

tip

If you use a firewall to restrict database access, you'll need to add Hex's IP addresses to your allowlist.

On this page