How to load data to Amazon redshift from different sources eg DynamoDB or Amazon EC2

+1 vote
How can I load data to Amazon Redshift from Amazon EC2 or DynamoDB?
Nov 20, 2018 in AWS by Jino
 • 5,820 points • 940 views

1 answer to this question.

0 votes
Hey @Jino, If you are talking about the different sources being ssh enabled host then they can be DynamoDB, Amazon-EC2 or EMR. You can use the COPY command to load/ copy data from Redshift to any of the following.

You can also use AWS Data pipeline and specify the source and destination.

The above two will serve the purpose.

Hope this helps!
answered Nov 20, 2018 by Nabarupa

Related Questions In AWS

0 votes
1 answer

How can I do Continuous data ingestion from on prem data sources to redshift

I can Recommend looking into AWS Schema ...READ MORE

answered Aug 8, 2018 in AWS by Priyaj
 • 58,020 points • 1,824 views
+1 vote
0 answers

How to get data from tables using java code - amazon DynamoDB

public void listAllCourses(@QueryParam("author") String authorQuery) { ...READ MORE

Aug 3, 2019 in AWS by Girija
edited Aug 5, 2019 by Kalgi • 1,936 views
0 votes
1 answer

How to restore a cluster from backup in Amazon Redshift

Amazon Redshift replicates all your data within ...READ MORE

answered Sep 28, 2018 in AWS by Archana
 • 4,170 points • 1,856 views
0 votes
1 answer

How to safely upgrade an Amazon EC2 instance from t1.micro to large?

Using AWS Management Console: Right-Click on the instance Instance ...READ MORE

answered Oct 8, 2018 in AWS by Priyaj
 • 58,020 points • 1,126 views
0 votes
1 answer

Unable to connect to putty and winscp

Check if the FTP ports are enabled ...READ MORE

answered Jul 20, 2018 in Cloud Computing by Gopalan
 • 1,360 points • 2,187 views
+2 votes
1 answer

How to connect to EC2 file directory using SFTP and Filezilla?

To connect to EC2 instance using Filezilla, ...READ MORE

answered Jul 27, 2018 in Cloud Computing by Gopalan
 • 1,360 points • 25,933 views
0 votes
1 answer

Not able to stream PDF, using AWS gateway/Lambda setup

I had a similar problem with trying ...READ MORE

answered Jul 31, 2018 in AWS by Priyaj
 • 58,020 points • 3,436 views
0 votes
1 answer

Experimenting with AWS API Gateway default response and triggering AWS Lambda

You can try out the following steps  Post ...READ MORE

answered Aug 16, 2018 in AWS by Deepthi
 • 300 points • 1,100 views
+3 votes
6 answers

How to move files from amazon ec2 to s3 bucket using command line

Hey, 3 ways you can do this: To ...READ MORE

answered Oct 9, 2018 in AWS by Omkar
 • 69,220 points • 20,001 views
0 votes
2 answers

How to configure Amazon EC2 command line interface?

You can use this command to create ...READ MORE

answered Feb 23, 2019 in AWS by Shashank
 • 1,370 points • 1,166 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.