RudderStack IAM role for Redshift

This guide contains the steps to create an IAM role for authenticating RudderStack while setting up the following resources:

• Redshift destination
• Redshift Reverse ETL source

Create RudderStack IAM role

This section contains the steps to set up a new RudderStack IAM role with the required permissions to access your Redshift database.

Create policy

1. Sign in to your AWS Management Console and open the IAM console.
2. Go to Policies > Create policy. See Creating IAM policies guide for more information.
3. Choose the JSON option. Then, paste the JSON (shown below) depending on whether the Use Redshift Serverless connection setting is toggled on or off:

{
  "Version": "2012-10-17",
  "Statement": [{
      "Action": "redshift-serverless:GetCredentials",
      "Effect": "Allow",
      "Resource": [
        "arn:aws:redshift-serverless:${Region}:${Account}:workgroup/${WorkgroupId}"
      ],
      "Sid": "VisualEditor0"
    },
    {
      "Action": [
        "redshift-data:BatchExecuteStatement",
        "redshift-data:ExecuteStatement"
      ],
      "Effect": "Allow",
      "Resource": [
        "arn:aws:redshift-serverless:${Region}:${Account}:workgroup/${WorkgroupId}"
      ],
      "Sid": "VisualEditor1"
    },
    {
      "Action": [
        "redshift-data:GetStatementResult",
        "redshift-data:CancelStatement",
        "redshift-data:DescribeStatement"
      ],
      "Effect": "Allow",
      "Resource": "*",
      "Sid": "VisualEditor2"
    }
  ]
}

{
  "Version": "2012-10-17",
  "Statement": [{
      "Action": "redshift:GetClusterCredentials",
      "Effect": "Allow",
      "Resource": [
        "arn:aws:redshift:${Region}:${Account}:dbuser:${ClusterIdentifier}/${DbUser}",
        "arn:aws:redshift:${Region}:${Account}:dbname:${ClusterIdentifier}/${DbName}"
      ],
      "Sid": "VisualEditor0"
    },
    {
      "Action": [
        "redshift-data:BatchExecuteStatement",
        "redshift-data:ExecuteStatement"
      ],
      "Effect": "Allow",
      "Resource": [
        "arn:aws:redshift:${Region}:${Account}:cluster:${ClusterIdentifier}"
      ],
      "Sid": "VisualEditor1"
    },
    {
      "Action": [
        "redshift-data:GetStatementResult",
        "redshift-data:CancelStatement",
        "redshift-data:DescribeStatement"
      ],
      "Effect": "Allow",
      "Resource": "*",
      "Sid": "VisualEditor2"
    }
  ]
}

Set up new IAM role

1. Sign in to your AWS Management Console and open the IAM console.
2. In the left navigation pane, click Roles followed by Create role.
3. Under Trusted entity type, select AWS account:

4. Select Another AWS account and under Account ID, enter 422074288268, the account ID associated with RudderStack.
5. Under Options check Require external ID and enter your workspace ID as the External ID.

RudderStack currently does not support MFA setting that restricts the role only to the users who sign in using multi-factor authentication (MFA). Hence, do not check the Require MFA option.

6. Review all settings carefully and click Next to proceed.
7. In the policy selection screen, add the policy created in the Create policy section.
8. Review all settings carefully and click Next to proceed.
9. Enter a unique name for your role. Note that this name cannot be distinguished by case. For example, you cannot create a role named RUDDERSTACK if rudderstack already exists.

You cannot edit the name of the role after it has been created.

10. Enter the role description.
11. To edit the use case or permissions for the role, click the Edit button next to the Step 1: Select trusted entities or Step 2: Add permissions, respectively.

12. Optional: You can also add metadata to the role by attaching tags as key-value pairs. For more information, refer to the Tagging IAM resources guide.
13. Click Create role to complete the setup.
14. Finally, note the ARN of this newly created role.

Use IAM role during Redshift setup

You can use the RudderStack IAM role to authenticate to Redshift for the following use cases:

Warehouse destination

1. Toggle on the Use IAM for authentication setting.
2. Specify the below settings depending on whether the Use Redshift Serverless connection setting is toggled on or off:

See the Redshift destination setup guide for more details.

Reverse ETL source

1. Select IAM as the Authentication Type.
2. Enter the ARN of the RudderStack IAM role in the IAM Role ARN setting.
3. Specify the below settings:

• Cluster identifier: Enter your AWS cluster ID.
• Cluster region: Enter your AWS cluster region.

See the Redshift Reverse ETL source setup guide for more details.

Questions? Contact us by email or on Slack