Docs
Sign up now
  • Getting started
    • Welcome to Sortment
    • Core Concepts
  • Schema
    • Overview
    • Related and Events Table
    • Setting Up Related Table
    • Setting Up Events Table
    • Custom Properties
  • ENGAGE
    • Audiences
      • Creating Audience
      • Audience Filters
      • Campaign Event Filters
      • Creating Audience Using SQL Builder
      • Managing Audiences
      • Audience Insights
    • Traits
      • Use Cases
      • Calculated Traits
        • Advanced Mode
      • Dynamic Traits
    • Profiles
      • User Profile View
    • Campaigns
      • Overview
      • Building a Campaign
      • Campaign Reports
        • Glossary
      • Conversion Tracking
  • Journeys
    • Getting Started
    • Journey Builder
    • Journey Components
      • Trigger
      • Delays
      • Flow Control
      • Action blocks
    • Tutorial: Creating a journey
    • Journey Settings
  • Connector
    • Overview
    • Getting started
      • Iterable
      • Klaviyo
  • Enable Data Sync
  • Setup
    • Data Warehouses
      • Snowflake
      • BigQuery
      • Redshift
      • Databricks
      • PostgreSQL
    • Cloud Bucket Storage
      • Amazon S3 for Snowflake
      • Google Cloud Storage for BigQuery
      • Amazon S3 for Redshift
      • Amazon S3 for Databricks
    • Communication Channels
      • Email
        • SendGrid
        • SES
        • Mailmodo
      • SMS
        • MSG91
        • Gupshup
      • WhatsApp
        • Meta (Facebook)
          • Add new Phone Number to Meta
        • Gupshup Enterprise
        • WATI
        • Gallabox
        • Yellow.ai
        • Kaleyra.io
    • Real-time Events
      • Setting up Event Source
      • Whitelist Event Payload
  • Settings
    • Sync Schedules
    • Audit Logs
    • Subscription Groups And Contact Fields
    • Delivery Controls
    • Test Profiles
    • Alerts
  • Data and Security
    • Technical Overview
    • Warehouse Data Practices
    • Data Access And Usage
    • Security Compliance
    • Audit Logs
    • Privacy Policy
Powered by GitBook
On this page
  • Connection configuration
  • AWS credentials setup

Was this helpful?

  1. Setup
  2. Cloud Bucket Storage

Amazon S3 for Redshift

PreviousGoogle Cloud Storage for BigQueryNextAmazon S3 for Databricks

Last updated 9 days ago

Was this helpful?

As discussed in , Amazon S3 is required for several data-related use cases in Sortment.

In AWS, accessing S3 via Redshift requires IAM Role ARN to prevent exposing user or access key details via SQL query.

For APIs, access is managed via Access Keys.

Connection configuration

Following details are requied on Sortment for S3 connection for Redshift:

  • AWS Region: The geographical region where your AWS services, including S3 and Redshift, are deployed. Examples include us-east-1 (N. Virginia) or ap-south-1 (Mumbai). In your → Click on your profile (top-right) → See the selected region.

  • AWS S3 Bucket Name: A globally unique name assigned to an S3 bucket where you store and retrieve data. On → Go to S3 → Locate your bucket under “Buckets” list.

  • Access Key ID: A unique identifier for an AWS IAM user or service that allows programmatic access to AWS services. On → IAM → Users → Select your user → Security Credentials tab → Generate Access Key.

  • Secret Access Key: A secret key paired with the Access Key ID, used for signing API requests securely. Generated alongside the Access Key ID in IAM (only shown once). If lost, you must generate a new pair.

  • IAM Role ARN: A unique identifier for an IAM Role that allows Redshift to interact with S3. On → IAM → Roles → Find your role → Copy the Role ARN.

AWS credentials setup

This region for S3 Bucket should be same as your Redshift region for lower data egress costs.

Follow these steps to setup an S3 bucket for Sortment:

Creating a bucket

  1. Click on "Create bucket."

  2. Enter a unique bucket name (globally unique across AWS).

  3. Select an AWS region for the bucket. This should be same as your Redshift cluster region.

  4. Create the bucket.

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. Update {$bucket-name} to the bucket created above. Give your policy a name and create the policy.

For Redshift to load data into an S3 bucket, it needs access to list all buckets it has access to. This is covered with resource level policy below.

{
	"Version": "2012-10-17",
	"Statement": [
		{
			"Effect": "Allow",
			"Action": "s3:*",
			"Resource": [
				"arn:aws:s3:::{$bucket-name}",
				"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. This will be used in S3 setup form on Sortment.

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.

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

Sign in to the AWS Management Console and .

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

cloud bucket storage setup
AWS Console
AWS Console
AWS Console
AWS Console
navigate to the S3 service
IAM article