Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions,
see Getting Started with Amazon Web Services in China
(PDF).
Using Amazon Redshift with other
services
This section describes how you can use other services as sources and destinations for Amazon Redshift data.
Amazon Redshift integrates with other Amazon services to enable you to move, transform, and load
your data quickly and reliably, using data security features.
- S3
-
Amazon Simple Storage Service (Amazon S3) is a web service that stores data in the cloud. Amazon Redshift leverages
parallel processing to read and load data from multiple data files stored in Amazon S3
buckets. For more information, see Loading data from Amazon S3.
You can also use parallel processing to export data from your Amazon Redshift data
warehouse to multiple data files on Amazon S3. For more information, see Unloading data in Amazon Redshift.
- DynamoDB
-
Amazon DynamoDB is a fully managed NoSQL database service. You can use the COPY command
to load an Amazon Redshift table with data from a single Amazon DynamoDB table. For more
information, see Loading data from an Amazon DynamoDB
table.
- SSH
-
You can use the COPY command in Amazon Redshift to load data from one or more remote hosts,
such as Amazon EMR clusters, Amazon EC2 instances, or other computers. COPY connects to the
remote hosts using SSH and runs commands on the remote hosts to generate data.
Amazon Redshift supports multiple simultaneous connections. The COPY command reads and
loads the output from multiple host sources in parallel. For more information, see
Loading data from remote hosts.
- Amazon Data Pipeline
-
You can use Amazon Data Pipeline to automate data movement and transformation into
and out of Amazon Redshift. By using the built-in scheduling capabilities of Amazon Data Pipeline, you can
schedule and run recurring jobs without having to write your
own complex data transfer or transformation logic. For example, you can set up a
recurring job to automatically copy data from Amazon DynamoDB into Amazon Redshift. For a
tutorial that walks you through the process of creating a pipeline that periodically
moves data from Amazon S3 to Amazon Redshift, see Copy data to Amazon Redshift using Amazon Data Pipeline in the Amazon Data Pipeline Developer Guide.
- Amazon DMS
-
You can migrate data to Amazon Redshift using Amazon Database Migration Service. Amazon DMS can migrate your data to and
from most widely used commercial and open-source databases such as Oracle,
PostgreSQL, Microsoft SQL Server, Amazon Redshift, Aurora DB cluster, DynamoDB, Amazon S3, MariaDB, and MySQL. For
more information, see Using an
Amazon Redshift database as a target for Amazon Database Migration Service.