amazon-redshift Getting started with amazon-redshift Installation or Setup

Example

As shown in the step by step guide (getting started with Amazon Redshift),it involves :

• Step 1: Set Up Prerequisites

• Step 2: Launch a Sample Amazon Redshift Cluster

• Step 3: Authorize Access to the Cluster

• Step 4: Connect to the Sample Cluster

Setting Up Prerequisites

Setting up Prerequisites involves Signing Up for AWS account and installing SQL Client Drivers and Tools like SQL Workbench/J

To install SQL Workbench J and configure it:

• Use this link to download generic package for all systems (sql-workbench) . Assuming you have all its prerequisites installed .
• Get the appropriate JDBC/ODBC Driver.
• Using the script in the installation directory launch SQL-Workbench .
• Open Connection Window > Manage Drivers > Browse and select the driver file.
• In the Select Connection Profile Window. Select the created driver in the Driver box. Paste the URL from the redshift cluster created (JDBC URL from the Amazon Redshift console) and the master user Username , Password.

Launch a Sample Amazon Redshift Cluster

• Click on Launch Cluster from Amazon Redshift Dashboard
• On cluster details page choose any Cluster Identifier, Database Name, Database Port (Choose an open port in your firewall since you cannot change the port number once the cluster is created.), Master User Name, Master User Password. On the Node Configuration page , select the Version (Redshift Version) , Node Type , Cluster Type and Number of Compute Nodes.
• Based on the EC2-VPC or EC2 Classic platform you select, the security steps vary for authorizing your cluster. For the rest of the pages you can use the default settings for now.

Authorize Cluster

For EC2-VPC Platform, click on the created cluster name after opening Redshift cluster tab from navigation pane and go to the configuration tab. In cluster properties choose the security group. Edit the inbound and outbound rules(Protocol, Port Range ,Source) as per your requirements from the Inbound and Outbound Tab.

For EC2-Classic Platform ,click on the created cluster name after opening Redshift cluster tab from navigation pane and go to the configuration tab. Choose default under Cluster Properties , for Cluster Security Groups. Then Choose the cluster security group from the Security Groups tab, in the cluster security group list. Select CIDR/IP from the connection type in the security group connections tab and authorize it with an IP/Port.

Connect to the Sample Cluster

Follow the last step in setting up prerequisites.