Redshift

Overview

CloudMock emulates Amazon Redshift, supporting cluster lifecycle, snapshots, subnet groups, parameter groups, tagging, and basic SQL statement execution.

Supported Operations

Operation	Status	Notes
CreateCluster	Supported	Creates a Redshift cluster
DescribeClusters	Supported	Lists clusters
DeleteCluster	Supported	Deletes a cluster
ModifyCluster	Supported	Modifies cluster configuration
RebootCluster	Supported	Reboots a cluster
CreateClusterSnapshot	Supported	Creates a snapshot
DescribeClusterSnapshots	Supported	Lists snapshots
DeleteClusterSnapshot	Supported	Deletes a snapshot
RestoreFromClusterSnapshot	Supported	Restores a cluster from snapshot
CreateClusterSubnetGroup	Supported	Creates a subnet group
DescribeClusterSubnetGroups	Supported	Lists subnet groups
DeleteClusterSubnetGroup	Supported	Deletes a subnet group
CreateClusterParameterGroup	Supported	Creates a parameter group
DescribeClusterParameterGroups	Supported	Lists parameter groups
DeleteClusterParameterGroup	Supported	Deletes a parameter group
CreateTags	Supported	Adds tags to a resource
DeleteTags	Supported	Removes tags from a resource
DescribeTags	Supported	Lists tags
ExecuteStatement	Supported	Executes a SQL statement (stub)
DescribeStatement	Supported	Returns statement execution status
GetStatementResult	Supported	Returns stub query results

Quick Start

Node.js

import { RedshiftClient, CreateClusterCommand } from '@aws-sdk/client-redshift';

const client = new RedshiftClient({
  endpoint: 'http://localhost:4566',
  region: 'us-east-1',
  credentials: { accessKeyId: 'test', secretAccessKey: 'test' },
});

await client.send(new CreateClusterCommand({
  ClusterIdentifier: 'my-cluster',
  NodeType: 'dc2.large',
  MasterUsername: 'admin',
  MasterUserPassword: 'Password123',
  NumberOfNodes: 2,
}));

Python

import boto3

client = boto3.client('redshift',
    endpoint_url='http://localhost:4566',
    region_name='us-east-1',
    aws_access_key_id='test',
    aws_secret_access_key='test')

client.create_cluster(
    ClusterIdentifier='my-cluster',
    NodeType='dc2.large',
    MasterUsername='admin',
    MasterUserPassword='Password123',
    NumberOfNodes=2)

Configuration

cloudmock.yml

services:
  redshift:
    enabled: true

Known Differences from AWS

• No actual data warehouse is provisioned
• SQL statements are not executed; results are stubs
• Snapshots are metadata-only and restore creates a new empty cluster