Copy Data to Amazon Redshift Using AWS Data Pipeline (original) (raw)

This tutorial walks you through the process of creating a pipeline that periodically moves data from Amazon S3 to Amazon Redshift using either the Copy to Redshift template in the AWS Data Pipeline console, or a pipeline definition file with the AWS Data Pipeline CLI.

Amazon S3 is a web service that enables you to store data in the cloud. For more information, see the Amazon Simple Storage Service User Guide.

Amazon Redshift is a data warehouse service in the cloud. For more information, see theAmazon Redshift Management Guide.

This tutorial has several prerequisites. After completing the following steps, you can continue the tutorial using either the console or the CLI.

Contents

• Before You Begin: Configure COPY Options and Load Data
• Set up Pipeline, Create a Security Group, and Create an Amazon Redshift Cluster
• Copy Data to Amazon Redshift Using the Command Line

Using the CLI

Before You Begin: Configure COPY Options

Did this page help you? - Yes

Thanks for letting us know we're doing a good job!

If you've got a moment, please tell us what we did right so we can do more of it.

Did this page help you? - No

Thanks for letting us know this page needs work. We're sorry we let you down.

If you've got a moment, please tell us how we can make the documentation better.