Loading Data into Amazon Redshift from Amazon S3

http://insights.iolap.com/author/dhafner/

Danijel Hafner is a BI Developer at iOLAP d.o.o (a subsidiary of iOLAP Inc.) located in Rijeka, Croatia. He graduated from Faculty of Organization and Informatics in Varaždin, Croatia. Danijel has been with iOLAP since 2010 and has worked on several highly visible projects in the U.S. He specializes in Data Warehousing and ETL development.

View all author posts →

Amazon offers loading data to Redshift either from flat files that are stored in an Amazon S3 bucket or from Amazon DynamoDB table. In this article, I will show you how to load data from your local machine to Amazon Redshift using the Amazon S3 service. Also, for inserting data to Amazon Redshift, I will show you how to use COPY command.

Due to the number of illustrations in this article, it is best to download the full article in PDF format.

To do so, click here: Amazon Redshift Data Load