Amazon Redshift

​

Amazon Redshift Setup

​

Step 1: Create an IAM User

1. Go to AWS IAM Console
2. Click Users → Create user
3. Enter a name (e.g., bondata-redshift)
4. Click Next → Attach policies directly

​

Step 2: Attach Permissions

{
  "Version": "2012-10-17",
  "Statement": [
    {
      "Effect": "Allow",
      "Action": [
        "redshift:GetClusterCredentials",
        "redshift:DescribeClusters",
        "redshift-data:ExecuteStatement",
        "redshift-data:GetStatementResult",
        "redshift-data:DescribeStatement"
      ],
      "Resource": "*"
    }
  ]
}

​

Step 3: Create Access Keys

1. Go to your new user → Security credentials
2. Click Create access key
3. Select Third-party service → Next
4. Copy the Access Key ID and Secret Access Key

​

Step 4: Get Cluster Details

• Cluster Identifier: Found in Redshift console (e.g., my-cluster)
• AWS Region: The region of your cluster (e.g., us-east-1)
• Workgroup: For Serverless Redshift only

​

Step 5: Enter Credentials

​

Required Fields