Overview
Amazon Redshift is AWS's petabyte-scale columnar data warehouse. The Automize Redshift connector covers cluster management, snapshots, and SQL execution via the Redshift Data API (no JDBC/ODBC required).
- Regions: Regional. Clusters live in one region.
- Plans: Provisioned clusters (RA3 + DC2 node types) or Serverless. Reserved instances for steady workloads.
Setting up the connection
Auth type: aws_sigv4.
- AWS IAM → user + AmazonRedshiftFullAccess + AmazonRedshiftDataFullAccess.
- Cluster needs a SecretsManager secret OR DB user creds for the Data API.
- In Automize → Settings → Connectors → AWS Redshift. Paste keys + region.
Find your credentials at https://us-east-1.console.aws.amazon.com/iam/home.
Rate limits
Data API throttles at ~10 concurrent statements per cluster. Cluster management APIs at ~5 TPS.
Data model
Compute + storage:
Cluster (multi-node) ─── Databases ─── Schemas ─── Tables ─── Rows
└─ Snapshots (manual + automated)
Data API: REST-based query execution (no JDBC driver needed)Available operations
17 operations available. Click any row to jump to its detail.
| Operation | Category | What it does |
|---|---|---|
| Batch Execute SQL | General | Execute multiple SQL statements |
| Create Cluster | General | Create a new Redshift cluster |
| Create Snapshot | General | Create a cluster snapshot |
| Delete Cluster | General | Delete a Redshift cluster |
| Delete Snapshot | General | Delete a cluster snapshot |
| Describe Snapshots | General | List cluster snapshots |
| Describe Clusters | General | List Redshift clusters |
| Describe Statement | General | Get status of a SQL statement |
| Execute SQL | General | Execute a SQL statement via the Data API |
| Get Statement Result | General | Get results of a completed SQL statement |
| List Statements | General | List recent SQL statements |
| Modify Cluster | General | Modify cluster settings |
| Pause Cluster | General | Pause a cluster |
| Reboot Cluster | General | Reboot a cluster |
| Resize Cluster | General | Resize a cluster |
| Restore from Snapshot | General | Restore a cluster from a snapshot |
| Resume Cluster | General | Resume a paused cluster |
Operations
Batch Execute SQL
Execute multiple SQL statements
No input parameters.
Create Cluster
Create a new Redshift cluster
No input parameters.
Tips
- Heavy – Provisioned cluster. NodeType + NumberOfNodes + MasterUsername + DBName.
- Takes 10-20 min to provision. For Serverless use create-namespace (not exposed here).
Create Snapshot
Create a cluster snapshot
No input parameters.
Delete Cluster
Delete a Redshift cluster
No input parameters.
Delete Snapshot
Delete a cluster snapshot
No input parameters.
Describe Snapshots
List cluster snapshots
No input parameters.
Describe Clusters
List Redshift clusters
No input parameters.
Tips
- Filter by ClusterIdentifier. Returns endpoint + node type + status.
Describe Statement
Get status of a SQL statement
No input parameters.
Tips
- Status: SUBMITTED, PICKED, STARTED, FINISHED, FAILED, ABORTED.
Execute SQL
Execute a SQL statement via the Data API
No input parameters.
Tips
- SQL via Data API. Async – returns statementId.
- ClusterIdentifier + Database + DbUser (or SecretArn) + Sql.
- Poll Describe Statement for status.
Get Statement Result
Get results of a completed SQL statement
No input parameters.
Tips
- Returns columnar results. Pages via NextToken.
List Statements
List recent SQL statements
No input parameters.
Modify Cluster
Modify cluster settings
No input parameters.
Pause Cluster
Pause a cluster
No input parameters.
Tips
- Stops compute, retains storage. Cheaper. Use Resume Cluster to restart.
Reboot Cluster
Reboot a cluster
No input parameters.
Resize Cluster
Resize a cluster
No input parameters.
Restore from Snapshot
Restore a cluster from a snapshot
No input parameters.
Resume Cluster
Resume a paused cluster
No input parameters.
Tips
- Restart paused cluster. ~5 min to become available.
FAQ
- Serverless vs Provisioned?
- Serverless auto-scales + pay-per-RPU-hour, great for spiky workloads. Provisioned cheaper for steady high utilisation.
- Why is my SQL taking forever?
- Compute capacity bound. Check WLM queue, consider scaling, or use SORTKEY/DISTKEY tuning.