Amazon Redshift Manuel d'utilisateur

Amazon RedshiftGetting Started GuideAPI Version 2012-12-01

Use the following values if you are launching your cluster in the EC2-Classic platform:• Cluster Parameter Group: select the default parameter group.•

8. A confirmation page appears and the cluster will take a few minutes to finish. Click Close to returnto the list of clusters.9. On the Clusters page

4. After your security group opens in the Amazon EC2 console, click the Inbound tab.5. Click Edit, and enter the following, then click Save:• Type: Cu

4. On the Security Groups tab, in the cluster security group list, click the cluster security group whoserules you want to manage.5. On the Security G

After you complete this step, you can determine whether you want to load sample data from Amazon S3in Step 5: Load Sample Data from Amazon S3 (p. 13)

Click the folder icon next to the Library box, navigate to the location of the driver, click it, and thenclick Open.If the Please select one driver di

12. Click OK.Step 5: Load Sample Data from Amazon S3At this point you have a database called dev and you are connected to it. Now you will create some

likebroadway boolean, likemusicals boolean);create table venue( venueid smallint not null distkey sortkey, venuename varchar(100), venuecity varchar(

command. For more information about the syntax, go to COPY in the Amazon Redshift DatabaseDeveloper Guide.Copy and execute the following copy statemen

3. Now try the example queries. For more information, go to SELECT in the Amazon Redshift DeveloperGuide.-- Get definition for the sales table.SELECT

Amazon Redshift: Getting Started GuideCopyright © 2015 Amazon Web Services, Inc. and/or its affiliates. All rights reserved.The following are trademar

The query information appears in a new Query tab. The following example shows the details of aquery you ran in a previous step.Step 6: Find Additional

If you used the EC2-Classic platform to launch your cluster, perform the steps in To Revoke Accessfrom the Cluster Security Group (p. 19).• Delete you

To Revoke Access from the Cluster Security Group1. In the Amazon Redshift console, in the navigation pane, click Clusters.2. Click examplecluster to o

5. On the cluster details window, the Cluster Status will display that the cluster being deleted.API Version 2012-12-0120Amazon Redshift Getting Start

Document HistoryThe following table describes the important changes since the last release of the Amazon Redshift GettingStarted Guide.Latest document

Table of ContentsGetting Started ...

Getting Started with AmazonRedshiftWelcome to the Amazon Redshift Getting Started. Amazon Redshift is a fully managed, petabyte-scaledata warehouse se

This tutorial is not meant for production environments, and does not discuss options in depth. After youcomplete the steps in this tutorial, you can u

For more information about using the Amazon Redshift JDBC or ODBC drivers, see ConfiguringConnections in Amazon Redshift.Determine Firewall RulesAs pa

3. In the left navigation pane, click Clusters and then click Launch Cluster.If you have no clusters in your selected region, your console will look s

5. On the Node Configuration page, select the following values and then click Continue:• Node Type: dw2.large• Cluster Type: Single Node6. On the Addi

Use the following values if you are launching your cluster in the EC2-VPC platform:• Cluster Parameter Group: select the default parameter group.• Enc