Amazon Redshift

Overview

Push your ecommerce data to Amazon Redshift for scalable SQL analytics within the AWS ecosystem, with tight integration with other AWS services.

Setup

1. 1

   Create a Redshift cluster in the AWS Console (or use an existing one).

2. 2

   Ensure the cluster is publicly accessible and the security group allows inbound traffic on port 5439.

3. 3

   Go to Dashboard > Outputs, click Connect on Amazon Redshift, and enter your host, port, database, and credentials.

4. 4

   Data syncs automatically to your Redshift cluster.

Tips

• You can reset your password under Actions > Modify on the cluster page.
• For production use, consider using a dedicated user with limited permissions rather than the admin account.

Fields Required

Setup Guide

1. 1

   Sign in to the AWS Console and go to Redshift.

   https://console.aws.amazon.com/redshiftv2/
2. 2

   Click "Clusters" in the sidebar and select your cluster (or create one).

3. 3

   On the cluster details, find the Endpoint — the part before the colon is your Host.

4. 4

   The port is usually 5439 (shown after the colon in the endpoint).

5. 5

   The database name is the part after the slash (default is "dev").

6. 6

   Use the admin username and password you set when creating the cluster.