Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.iru.com/llms.txt

Use this file to discover all available pages before exploring further.

​
About Amazon Redshift

This connector targets provisioned Redshift clusters - parameter groups, subnet groups, snapshots, logging status, and encryption flags via redshift:Describe* / ListRecommendations. For Redshift Serverless or the Data API statement layer, use the dedicated Amazon Redshift Serverless and Amazon Redshift Data sources.

​
How it works

Attach AmazonRedshiftReadOnlyAccess, or least-privilege: 
{
  "Version": "2012-10-17",
  "Statement": [
    {
      "Effect": "Allow",
      "Action": ["redshift:Describe*", "redshift:ListRecommendations"],
      "Resource": "*"
    }
  ]
}
DetailValue
CategoryDatabases
AuthenticationCross-account IAM role

​
Prerequisites

  • IAM admin rights in the account that hosts clusters.

​
Connect AWS Redshift to Iru

​
Copy the trust policy from Iru

1

Open Sources

In Iru Compliance, on the left navigation bar, expand Compliance and select Sources.
Left navigation: Compliance expanded, Sources selected
2

Turn on AWS Redshift

Find AWS Redshift (use Category or Search by name or description). On that card, turn on the toggle. Leave the wizard tab open.
3

Copy the trust policy JSON

{
  "Version": "2012-10-17",
  "Statement": [
    {
      "Effect": "Allow",
      "Principal": {
        "AWS": "arn:aws:iam::753695775620:role/IruConnect"
      },
      "Condition": {
        "StringEquals": {
          "sts:ExternalId": "YOUR_EXTERNAL_ID"
        }
      },
      "Action": "sts:AssumeRole"
    }
  ]
}

​
Create the IAM role in AWS

1

Start Create role

Open IAM → Roles → Create role.
2

Configure trusted entity

Choose AWS account → Another AWS account. Enter 753695775620 (or the ID Iru shows). Enable Require external ID and paste the external ID from Iru.
3

Attach Redshift read permissions

Attach AmazonRedshiftReadOnlyAccess, or attach an inline policy matching the JSON under How it works above.
4

Name the role and copy the ARN

Name the role, create it, and copy the Role ARN.

​
Submit the role ARN in Iru

1

Paste the IAM Role ARN

Paste the Role ARN into the connector where the wizard prompts for it.
2

Confirm the source is Active

Submit until AWS Redshift shows Active.

​
Troubleshooting

Check pop-up blocker settings for the Iru site and try again.
Use Amazon Redshift Serverless source (redshift-serverless:*).
Confirm redshift:DescribeClusterSnapshots is allowed (included in Describe*).
External ID mismatch.

​
See also