Skip to main content

​
Amazon Redshift Setup

Follow these steps to set up IAM credentials for BonData.

​
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

Create a policy with these 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

Enter the Access Key ID, Secret Access Key, and cluster details in BonData.

​
Required Fields

FieldDescription
AWS RegionThe AWS region of your Redshift cluster (e.g., us-east-1)
Cluster IdentifierFor provisioned Redshift clusters
WorkgroupFor Redshift Serverless only
Db UserThe database user to connect as
Access Key IDAWS IAM access key
Secret Access KeyAWS IAM secret key