Redshift
Coming Soon
Redshift support is under active development. This page describes the planned integration.
Overview
Amazon Redshift is a columnar data warehouse with massively parallel processing (MPP) architecture. It's well-suited for analytical workloads on AWS-hosted data.
┌─────────────────┐ ┌──────────────────┐ ┌─────────────────┐
│ GradientHarbor │────▶│ Redshift │────▶│ S3 / Glue │
│ │ SQL │ │ │ Data Lake │
│ AI Agent │◀────│ MPP Cluster │◀────│ (Spectrum) │
│ Dashboards │ │ (columnar) │ │ │
└─────────────────┘ └──────────────────┘ └─────────────────┘Planned Configuration
Password Authentication
| Field | Description |
|---|---|
| Host | Cluster endpoint (e.g., my-cluster.abc123.us-west-2.redshift.amazonaws.com) |
| Port | Cluster port (default: 5439) |
| Database | Database name |
| Username | Database user |
| Password | User password |
IAM Authentication
| Field | Description |
|---|---|
| Host | Cluster endpoint |
| Port | Cluster port (default: 5439) |
| Database | Database name |
| Database User | Redshift database user to assume |
| IAM Role ARN | AWS IAM role ARN for authentication |
Why Redshift
- Columnar storage — Efficient analytical queries on large datasets
- Redshift Spectrum — Query data directly in S3 without loading
- Concurrency scaling — Automatically adds capacity for concurrent dashboard viewers
- AWS integration — Native integration with S3, Glue, IAM