Prerequisites
- A Redshift cluster with a publicly accessible endpoint, or network-level access configured.
- A database user with read access.
Required fields
| Field | Description | Example |
|---|---|---|
| Name | A display name for this datasource. | Graphics Press warehouse |
| Host | The Redshift cluster endpoint. | my-cluster.abc123.us-east-1.redshift.amazonaws.com |
| Port | The port Redshift is listening on. | 5439 |
| Database | The database name. | my_database |
| User | The database user. | admin |
| Password | The user’s password. |
Optional fields
| Field | Description |
|---|---|
| SSL | Enable SSL for encrypted connections. Recommended for Redshift. |
Steps
- Open Settings → Datasources → New.
- Enter a name and select Amazon Redshift as the type.
- Fill in the fields above.
- Click Test connection to verify.
- Click Create.
Tips
- Find your cluster endpoint in the AWS Console under Amazon Redshift → Clusters → your cluster → General information.
- Ensure your Redshift security group allows inbound traffic on port 5439 from Mora’s IP.