This a great place to get started with Redshift: http://docs.aws.amazon.com/redshift/latest/gsg/getting-started.html. There are a couple of pieces of information in the step by step instructions I wanted to elaborate on:
1. Creating a cluster subnet group is done in the Redshift area of the console as seen below. This is not evident in the instructions:
This of course assumes a VPC with two public subnets and a route to an IGW has been created.
2. The copy command is issued from SQL Workbench.copy venue from 's3://awssampledb/tickit/venue_pipe.txt' CREDENTIALS 'aws_access_key_id=<your access key>;aws_secret_access_key=<you secret key>' delimiter '|';
3. Make sure to set auto commit otherwise you need to commit each statements or block of statements and the example does not have commit commands.
1. Creating a cluster subnet group is done in the Redshift area of the console as seen below. This is not evident in the instructions:
This of course assumes a VPC with two public subnets and a route to an IGW has been created.
2. The copy command is issued from SQL Workbench.copy venue from 's3://awssampledb/tickit/venue_pipe.txt' CREDENTIALS 'aws_access_key_id=<your access key>;aws_secret_access_key=<you secret key>' delimiter '|';
3. Make sure to set auto commit otherwise you need to commit each statements or block of statements and the example does not have commit commands.
Really nice blog post.provided a helpful information.I hope that you will post more updates like this
ReplyDeleteAWS Online Training