> ## Documentation Index
> Fetch the complete documentation index at: https://docs.bondata.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Amazon Redshift

> Connect BonData to Amazon Redshift to sync your data warehouse tables

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](https://console.aws.amazon.com/iam/)
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:

```json theme={null}
{
  "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

| Field              | Description                                               |
| ------------------ | --------------------------------------------------------- |
| AWS Region         | The AWS region of your Redshift cluster (e.g., us-east-1) |
| Cluster Identifier | For provisioned Redshift clusters                         |
| Workgroup          | For Redshift Serverless only                              |
| Db User            | The database user to connect as                           |
| Access Key ID      | AWS IAM access key                                        |
| Secret Access Key  | AWS IAM secret key                                        |