Amazon S3 for Redshift

Prerequisite

Create an S3 bucket you want Sortment to give access to. This bucket URI will be required when creating policy and role for bucket access.

AWS credentials setup

To give Sortment access to S3 bucket on your AWS account, follow these steps to create an account:

Creating a policy

1. From your AWS console navigate to Identity and Access Management (IAM) > Access Management > Policies

   
2. In the JSON policy editor, use the following policy and update the bucket name to the bucket created above. Give your policy a name and create the policy.

{
    "Version": "2012-10-17",
    "Statement": [
        {
            "Effect": "Allow",
            "Action": "s3:*",
            "Resource": [
                "arn:aws:s3:::{$bucket-name}/*"
            ]
        }
    ]
}

Creating a role

1. Now, navigate to Identity and Access Management (IAM) > Access Management > Roles and click Create Role.

   
2. Give access to the policy created for sortment

   
3. Next, setup the name and description and create the role.

4. Copy the role ARN and paste it during the blob storage setup.

Associating role with your Redshift cluster

1. In Amazon Redshift console, choose Clusters, then choose the name of the cluster that you want to update.

2. In Actions dropdown, choose Manage IAM roles to display the current list IAM roles associated with the cluster.

3. On the Manage IAM roles page, choose the IAM role created earlier and then choose Add IAM role.

4. Save your changes to modify the cluster and allow Redshift access to the S3 bucket.

Configuring Access Key

The Access Key access type allows you to configure Sortment to use an IAM user by providing the user's Access Key ID and Secret Access Key.

If you need help generating these keys, consult the IAM article on this topic.

Once you have an Access Key ID and Secret Access Key, paste those values into the form and click Create.

Use the credentials generated above to connect Sortment to your S3 bucket and proceed.