How to upload data to AWS S3 and import to Redshift

For detail see:
http://docs.aws.amazon.com/redshift/latest/dg/tutorial-loading-data.html

1. At first let's create sample CSV(comma separated value) data on excel or spreedsheet.

2. upload it to S3.

 3.  Using SQL-Workbench let's copy those CSV data from S3. If you don't know how to create Redshift cluster and connect with SQL-Workbench see my previous post

How to quickly get started to use AWS Redshift

 If you already made connection with Redshift cluster, run following query:

copy part from 's3://<your-bucket-name>/path/yourfilename.csv' 
credentials 'aws_access_key_id=<Your-Access-Key-ID>;aws_secret_access_key=<Your-Secret-Access-Key>'
csv;

In order to connect with S3 you have to create own IAM credentials and use it.