Skip to main content

Setup Guide

This guide walks you through creating an IAM user, obtaining access keys, and setting up an Amazon Redshift cluster for use with the AWS Redshift data connector.

Prerequisites​

Step 1: Log in to the AWS Console​

Access the AWS Management Console.

Step 2: Create an IAM user​

  1. In the AWS Management Console, search for IAM in the services search bar and select it.

    Search IAM

  2. Select Users in the left navigation pane.

    Select Users

  3. Select Create user.

    Create user

  4. Enter a suitable User name and select Next.

    Specify user details

  5. Add the required permissions by adding the user to a group, copying permissions, or attaching policies directly (for example, AmazonRedshiftDataFullAccess). Select Next.

    Set user permissions

  6. Review the details and select Create user.

    Review and create user

Step 3: Get the access key ID and secret access key​

  1. Select the user you just created from the Users list.

    Select user

  2. Go to the Security credentials tab and select Create access key.

    Create access key

  3. Select your use case and select Next.

    Select use case

  4. Copy the Access key ID and Secret access key. Use these credentials to authenticate your integration.

    Retrieve access key

warning

The secret access key is shown only once. Copy both values immediately or download the CSV file. If lost, you must create a new access key pair.

Step 4: Set up a Redshift cluster​

  1. In the AWS Management Console, search for Redshift and select it.

    Navigate to Redshift

  2. Select Create cluster to start creating a new cluster.

    Create cluster

Configure cluster settings​

  1. Configure the cluster identifier, database name, credentials, and other relevant parameters.

    Configure cluster

  2. Configure security groups to control inbound and outbound traffic to your Redshift cluster.

    Configure security groups

  3. Record the database username set during cluster configuration — it will be used to authenticate your integration.

    Database configuration

  4. Review your settings and select Create cluster.

Wait for cluster availability​

Monitor the cluster status in the AWS Console until it shows as Available.

Wait for availability

note

Amazon Redshift also offers a serverless option that scales automatically without managing infrastructure. To configure Redshift Serverless, see the AWS documentation.