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.

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.