Skip to main content
Amazon Redshift is a fully managed, petabyte-scale cloud data warehouse from AWS, optimized for fast analytics on structured data. With BonData, you can connect to your Redshift cluster to read, enrich, and act on your warehouse data within Agent workflows.

​
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