Skip to content

Latest commit

 

History

History
123 lines (108 loc) · 6.92 KB

README.md

File metadata and controls

123 lines (108 loc) · 6.92 KB
Raw

LAB 1 - Creating Redshift Clusters

이 실습에서는 새로운 Redshift Cluster를 시작하고 연결을 설정하고 JDBC 클라이언트 도구를 구성합니다.

Contents

시작하기 앞서

  • Determine and capture the following information and login to the AWS Console. If you are new to AWS, you can create an account.
    • [Your-AWS_Account_Id]
    • [Your_AWS_User_Name]
    • [Your_AWS_Password]
  • Determine the [AWS Region Name] and [AWS Region Id] which is closest to you and switch your console to that Region.

Prerequisites

  • While Amazon Redshift does provide a web-based Query editor for executing simple queries which complete in under 3 minutes, for these labs, it is recommended you install a third-party tool. We will use SQL Workbench/J.
  • Once you have installed your third-party tool, you will need either a JDBC or ODBC driver. Amazon Redshift offers JDBC and ODBC drivers for download. See Connecting to an Amazon Redshift Cluster Using SQL Client Tools from the Amazon Redshift Documentation website.

Cloud Formation

To launch this cluster and configure security automatically using cloud formation, use the following link and skip ahead to Configure Client Tool.
Launch

Configure Security

VPC

Create or identify a VPC where you will launch your Redshift cluster. For our purposes we will create a VPC to isolate the traffic.

https://console.aws.amazon.com/vpc/home?#CreateVpc:

InternetGateway

Create or identify an Internet Gateway. For our purposes we will create an Internet Gateway. Once created, select the Internet Gateway and attach it to the VPC created earlier.

https://console.aws.amazon.com/vpc/home?#Create%20Internet%20Gateway:

Subnets

Create or identify a subnet with a default route to an Internet Gateway. For our purposes we will create a Subnet attached to the previously created VPC in two different Availability Zones to improve fault tolerance.

https://console.aws.amazon.com/vpc/home?#CreateSubnet:

Route Table

If you have created new subnets, you must create a Route Table with the default route pointed to the internet gateway and with the new subnets added.

https://console.aws.amazon.com/vpc/home?#CreateRouteTable:

Subnet Group

Create a Redshift Cluster Subnet Group containing the two subnets you created earlier by clicking the add all subnets for this VPC button.

https://console.aws.amazon.com/redshiftv2/home?#subnet-groups

Security Group

Create a Security Group associated to the VPC you created earlier. Edit the Security Group to create a rule which allows incoming connections from your IP Address.

https://console.aws.amazon.com/vpc/home#SecurityGroups:sort=groupId

S3 Access

Create an IAM Role with the type "Redshift" and the use-case of "Redshift - Customizable" and attach the AmazonS3ReadOnlyAccess and AWSGlueConsoleFullAccess policies to the role.

https://console.aws.amazon.com/iam/home?#/roles$new?step=type

Launch Redshift Cluster

Navigate to the Amazon Redshift Dashboard and click on the "Create Cluster" button.

https://console.aws.amazon.com/redshiftv2/home?#clusters
  • Cluster Configuration - Choose the node type and set the number of nodes. For these labs a dc2.large node type with 4 nodes will be suitable.
  • Cluster Details - Enter values as appropriate for your organization. Note the Master user password as you will not be able to retrieve this value later.
  • Cluster Permissions - Select the Role which you identified or created earlier to associate to the cluster, and click Add IAM role
  • Additional Configuration - Disable Use defaults and choose the VPC, Subnet Group, and VPC Security group you identified or created earlier.

Leave the remaining settings with their default values. Click Create Cluster to launch the Redshift cluster.

Configure Client Tool

  • See Prerequisites for more details on downloading and installing SQL Workbench/J and the Redshift JDBC Driver.
  • Launch SQL Workbench/J and navigate to [File | Manage Drivers].
  • Select "Amazon Redshift" and set the driver Library location to where you downloaded the Redshift JDBC Driver. Click Ok.
  • Navigate to [File | Connect Window] to create a new connection profile and modify the following settings and once complete click on the "Test Connection" button.
    • Name - "LabConnection"
    • Driver - Amazon Redshift (com.amazon.redshift.jdbc.Driver)
    • URL - Find this by navigating to the Cluster List, selecting your cluster, clicking on Properties and copying the Endpoint located in the Connection details.
    • Username - [Master user name]
    • Password - [Master user password]
    • Autocommit - Enabled

Run Sample Query

  • Run the following query to list the users within the redshift cluster.
select * from pg_user
  • If you receive the following results, you have established connectivity and this lab is complete.

Before You Leave

If you are done using your cluster, please think about decommissioning it to avoid having to pay for unused resources.