Amazon Redshift

Connection Details

FieldDescriptionExample
HostRedshift cluster endpointcluster.abc123.us-east-1.redshift.amazonaws.com
PortRedshift port (default 5439)5439
DatabaseDatabase nameanalytics
UsernameRedshift userreadonly_user
PasswordUser password••••••••

Setting Up

1

Go to Connectors → Database

Select Redshift as the database type.
Selecting Redshift
2

Enter connection details

Fill in the host, port, database name, username, and password.
Redshift connection form
3

Test connection

Testing Redshift connection
4

Select schemas and tables

Selecting Redshift tables
5

Save

Your Redshift data is now queryable.
Ensure your Redshift cluster’s security group allows inbound connections from Generate’s IP address.