Example: biology

Amazon Redshift - 入門ガイド - docs.aws.amazon.com

Amazon Redshift . API 2012-12-01. Amazon Redshift . Amazon Redshift : . Copyright 2019 Amazon Web Services, Inc. and/or its affiliates. All rights reserved. Amazon 's trademarks and trade dress may not be used in connection with any product or service that is not Amazon 's, in any manner that is likely to cause confusion among customers, or in any manner that disparages or discredits Amazon . All other trademarks not owned by Amazon are the property of their respective owners, who may or may not be affiliated with, connected to, or sponsored by Amazon . Amazon Redshift . Table of Contents .. 1. 1: .. 1. AWS .. 2.. 2. 2: IAM .. 2. Amazon Redshift IAM .. 2. 3: .. 3. Amazon Redshift .. 3. 4: .. 6. VPC (EC2-VPC Platform) .. 6. Amazon Redshift .. 7. 5: .. 8.. 8. SQL .. 11. 6: .. 15. 7: .. 19. ? .. 19.. 23. API 2012-12-01. iii Amazon Redshift . 1: . Amazon Redshift . Amazon Redshift Amazon Redshift . Amazon Redshift .. 1 Amazon Redshift 1.

Amazon Redshift 入門ガイド Amazon Redshift クラスターを起動するには 3. Amazon Redshift ダッシュボードで、[Quick launch cluster (クイック起動クラスター)] を選択しま

Tags:

  Docs

Information

Domain:

Source:

Link to this page:

Please notify us if you found a problem with this document:

Other abuse

Transcription of Amazon Redshift - 入門ガイド - docs.aws.amazon.com

1 Amazon Redshift . API 2012-12-01. Amazon Redshift . Amazon Redshift : . Copyright 2019 Amazon Web Services, Inc. and/or its affiliates. All rights reserved. Amazon 's trademarks and trade dress may not be used in connection with any product or service that is not Amazon 's, in any manner that is likely to cause confusion among customers, or in any manner that disparages or discredits Amazon . All other trademarks not owned by Amazon are the property of their respective owners, who may or may not be affiliated with, connected to, or sponsored by Amazon . Amazon Redshift . Table of Contents .. 1. 1: .. 1. AWS .. 2.. 2. 2: IAM .. 2. Amazon Redshift IAM .. 2. 3: .. 3. Amazon Redshift .. 3. 4: .. 6. VPC (EC2-VPC Platform) .. 6. Amazon Redshift .. 7. 5: .. 8.. 8. SQL .. 11. 6: .. 15. 7: .. 19. ? .. 19.. 23. API 2012-12-01. iii Amazon Redshift . 1: . Amazon Redshift . Amazon Redshift Amazon Redshift . Amazon Redshift .. 1 Amazon Redshift 1.

2 Amazon Redshift . Amazon Redshift Management Overview Amazon Redshift . Amazon Redshift .. Amazon Redshift ( ) Amazon Redshift .. Amazon Redshift PoC ( ) Amazon Redshift PoC ( ).. Amazon Redshift . Amazon Redshift .. 1: (p. 1). 2: IAM (p. 2). 3: Amazon Redshift (p. 3). 4: (p. 6). 5: (p. 8). 6: Amazon S3 (p. 15). 7: (p. 19). ? (p. 19) Amazon Redshift .. Important .. 1 USD Amazon Redshift .. Amazon Redshift .. (p. 19) .. 1: . Amazon Redshift .. AWS (p. 2). API 2012-12-01. 1. Amazon Redshift . AWS . (p. 2). AWS . AWS .. 1. [AWS ] . Note AWS AWS . [Sign in to a different account ( . )] IAM . [Sign-in using root account credentials ( . )] [ AWS ] . 2.. Amazon Redshift .. SQL .. Amazon Redshift . 5439 . Amazon Redshift .. 2: IAM . COPY Amazon S3 AWS .. IAM . IAM AWS AWS Identity and Access Management . AWS IAM . AWS .. Amazon Redshift Amazon S3 . IAM . Amazon Redshift IAM . 1. AWS IAM iam/ . API 2012-12-01. 2. Amazon Redshift . 3.

3 2. [Roles] . 3. [ ] . 4. [AWS Service (AWS )] [ Redshift .] . 5. [Select your use case ( )] [ Redshift - Customizable ( Redshift - . )] [Next: Permissions ( : )] . 6. [Attach permissions policies ( )] . [AmazonS3 ReadOnlyAccess] [Next: Review ( : )] . 7. [Role name ( )] . myRedshiftRole . 8. [ ] . 9.. 10. [Role ARN ( ARN)] . Amazon (ARN) 6: Amazon S3 . (p. 15) COPY .. 3: Amazon Redshift .. Amazon Redshift . Important ( . ) Amazon Redshift . 1 .. Amazon Redshift . 1. AWS Amazon Redshift https://.. Important IAM . Amazon Redshift Cluster Management Guide IAM . 2. [ . ( )] . API 2012-12-01. 3. Amazon Redshift . Amazon Redshift . 3. Amazon Redshift [Quick launch cluster ( )] .. Amazon Redshift . 4. [Cluster Specifications] [Launch cluster ( )] .. [Node type ( )]: [ ] . [Number of compute nodes ( )]: [2] . [ ID]: [ Redshift -cluster-1] . [ ]: [awsuser] . [ ] [ ]: .. [Database port ( )]: [5439] . [Available IAM roles ( IAM )]: [myRedshiftRole].

4 [dev] . API 2012-12-01. 4. Amazon Redshift . Amazon Redshift . Note (VPC) . VPC . VPC VPC . VPC EC2 Classic [ ] .. 5. [Close ( )] .. 6. [Clusters] [Cluster Status ( )]. [Cluster Status ( . )] [available ( )] [Database Health ( )] [healthy ( . )] . API 2012-12-01. 5. Amazon Redshift . 4: . 4: . Amazon Redshift .. EC2-VPC VPC (EC2-VPC. Platform) (p. 6) . EC2-Classic Amazon Redshift . (p. 7) . Note 2 .. VPC (EC2-VPC Platform) .. 1. Amazon Redshift [Clusters ( )] . 2. examplecluster [Configuration ( )] .. 3. [Cluster Properties ( )] [VPC Security Groups (VPC . )] . 4. Amazon EC2 [Inbound ( )] .. 5. [Edit ( )] [Save ( )] . [Type ( )]: [Custom TCP Rule ( TCP )] . [Protocol ( )]: [TCP] . [Port Range ( )]: . Amazon Redshift 5439 .. [Source ( )]: [Custom IP ( IP)] . Important .. API 2012-12-01. 6. Amazon Redshift . Amazon Redshift . Amazon Redshift .. 1. Amazon Redshift [Clusters ( )] . 2. examplecluster [Configuration ( )] .. 3. [Cluster Properties ( )] [Cluster Security Groups (.)]

5 ] [default ( )] . 4. [Security Groups ( )] .. 5. [Security Group Connections ( )] [Add Connection Type ( . )] . 6. [Connection Type ( )] [CIDR/IP] . [CIDR/IP to Authorize ( CIDR/IP)] [Authorize ( )] .. Important .. API 2012-12-01. 7. Amazon Redshift . 5: . 5: .. Amazon Redshift 2 . AWS . SQL .. SQL Workbench/j SQL .. (p. 8). SQL (p. 11).. Amazon Redshift . Amazon Redshift .. SQL . 100 MB (CSV) . EU ( ) ( : . ) . API 2012-12-01. 8. Amazon Redshift .. 50 . 500 .. 50 (WLM) .. 2 . 100 . VPC .. Amazon Redshift Database Developer Guide BEGIN .. AWS Identity and Access Management (IAM) AmazonRedshiftQueryEditor . AmazonRedshiftReadOnlyAccess AWS .. Amazon Redshift IAM . AmazonRedshiftQueryEditor AmazonRedshiftReadOnlyAccess . IAM IAM .. IAM . 1. AWS IAM iam/ . 2. [ ] . 3.. 4. [Add permissions] . 5. [Attach existing policies directly] . 6. [Policy names ( )] [AmazonRedshiftQueryEditor] . [AmazonRedshiftReadOnlyAccess] . 7. [Next: Review].

6 8. [Add permissions] .. SQL .. API 2012-12-01. 9. Amazon Redshift .. 1. AWS Amazon Redshift https://.. 2.. 3. [ ] [ ] . [ ]: [ Redshift -cluster-1] . [ ]: dev. [ ]: [awsuser]. [ ]: . 4. [Schema ( )] [public ( )] .. 5. [Run Query ( )] .. create table shoes(. shoetype varchar (10), color varchar(10));. 6. [ ] . 7. [Run Query ( )] .. insert into shoes values ('loafers', 'brown'), ('sandals', 'black');. 8. [ ] . 9. [Run Query ( )] .. select * from shoes;.. API 2012-12-01. 10. Amazon Redshift . SQL . SQL . SQL . PostgreSQL SQL . SQL Workbench/J .. SQL (p. 11). (p. 12). SQL Workbench/J (p. 13). 6: Amazon S3 (p. 15) . Amazon S3 ? (p. 19) . Amazon Redshift . SQL . Amazon Redshift Amazon Redshift JDBC ODBC . SQL SQL Workbench/J . DBMS . SQL SQL Workbench/J . Amazon Redshift JDBC SQL Workbench/J SQL. Workbench/J Amazon Redshift Cluster Management Guide . SQL Workbench/J Amazon EC2 . SQL Workbench/J .. API 2012-12-01. 11. Amazon Redshift .

7 SQL . Note . Amazon Redshift .. SQL Workbench/J . 1. SQL Workbench/J . 2. SQL Workbench/J .. 3. Installing and starting SQL Workbench/J SQL Workbench/J .. Important SQL Workbench/J Java . SQL Workbench/J . 4. JDBC Amazon Redshift JDBC SQL. Workbench/J . Amazon Redshift JDBC ODBC Amazon Redshift .. 1. Amazon Redshift [Clusters ( )] . 2. examplecluster [Configuration ( )] .. 3. [Configuration ( )] [Cluster Database Properties ( )] . JDBC URL . Note .. API 2012-12-01. 12. Amazon Redshift . SQL . SQL Workbench/J . 1: (p. 1) SQL Workbench/J .. 1. SQL Workbench/J . 2. [File ( )] [Connect window ( )] . 3. [Create a new connection profile ( )] . 4. [New profile ( )] . 5. [Manage Drivers ( )] [Manage Drivers ( )] .. 6. [Create a new entry ( )] [Name ( )] .. [Library ( )] . [Open ( )] . [Please select one driver ( 1 )] . [ ] [ ] [OK ( )]. [Classname ( )] SQL Workbench/J . [Sample URL ( URL)] [OK ( )] . API 2012-12-01. 13. Amazon Redshift .

8 SQL . 7. [Driver ( )] . 8. [URL] Amazon Redshift console JDBC URL . 9. [Username ( )] masteruser . 10. [Password ( )] .. 11. [Autocommit ( )] . 12. [Save profile list ( )] . 13. [OK] . 14. [SQL] [Execute Current ( )] .. create table shoes(. shoetype varchar (10), color varchar(10));. 15.. insert into shoes values ('loafers', 'brown'), ('sandals', 'black');. 16.. select * from shoes;. API 2012-12-01. 14. Amazon Redshift . 6: . 6: Amazon S3 .. dev .. Amazon S3 . Note SQL SQL .. Amazon Redshift . ? (p. 19) . 1.. create table dev . Amazon Redshift Database Developer Guide CREATE TABLE .. create table users(. userid integer not null distkey sortkey, username char(8), firstname varchar(30), lastname varchar(30), city varchar(30), state char(2), email varchar(100), phone char(14), likesports boolean, liketheatre boolean, likeconcerts boolean, likejazz boolean, likeclassical boolean, likeopera boolean, likerock boolean, likevegas boolean, likebroadway boolean, likemusicals boolean).

9 Create table venue(. venueid smallint not null distkey sortkey, venuename varchar(100), venuecity varchar(30), venuestate char(2), venueseats integer);. create table category(. catid smallint not null distkey sortkey, catgroup varchar(10), catname varchar(10), catdesc varchar(50));. create table date(. dateid smallint not null distkey sortkey, caldate date not null, day character(3) not null, week smallint not null, month character(5) not null, qtr character(5) not null, API 2012-12-01. 15. Amazon Redshift . 6: . year smallint not null, holiday boolean default('N'));. create table event(. eventid integer not null distkey, venueid smallint not null, catid smallint not null, dateid smallint not null sortkey, eventname varchar(200), starttime timestamp);. create table listing(. listid integer not null distkey, sellerid integer not null, eventid integer not null, dateid smallint not null sortkey, numtickets smallint not null, priceperticket decimal(8,2), totalprice decimal(8,2), listtime timestamp).

10 Create table sales(. salesid integer not null, listid integer not null distkey, sellerid integer not null, buyerid integer not null, eventid integer not null, dateid smallint not null sortkey, qtysold smallint not null, pricepaid decimal(8,2), commission decimal(8,2), saletime timestamp);. 2. COPY Amazon S3 . Note Amazon S3 DynamoDB Amazon Redshift . COPY COPY . Amazon Redshift Database Developer Guide COPY . Amazon Redshift Amazon S3 . AWS .. Amazon S3 .. Amazon Redshift Database Developer Guide CREDENTIALS . IAM .. Note Amazon S3 COPY . S3 ServiceException: Access Denied . COPY IAM ARN . copy users from 's3://awssampledbuswest2/ '. credentials 'aws_iam_role=<iam-role-arn>'. delimiter '|' region 'us-west-2';. API 2012-12-01. 16. Amazon Redshift . 6: . IAM CREDENTIALS <iam-role- arn> 2: IAM (p. 2) IAM ARN .. COPY . copy users from 's3://awssampledbuswest2/ '. credentials 'aws_iam_role=arn:aws:iam::123456789012: role/myRedshiftRole'.


Related search queries