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 IAMSearch IAM

  2. Select Users in the left navigation pane.

    Select UsersSelect Users

  3. Select Create user.

    Create userCreate user

  4. Enter a suitable User name and select Next.

    Specify user detailsSpecify 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 permissionsSet user permissions

  6. Review the details and select Create user.

    Review and create userReview 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 userSelect user

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

    Create access keyCreate access key

  3. Select your use case and select Next.

    Select use caseSelect use case

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

    Retrieve access keyRetrieve 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 RedshiftNavigate to Redshift

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

    Create clusterCreate cluster

Configure cluster settings​

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

    Configure clusterConfigure cluster

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

    Configure security groupsConfigure security groups

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

    Database configurationDatabase 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 availabilityWait for availability
note

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

Last updated on
On this page
Was this page helpful?
Report an issue