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
854 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,100 points
1,739 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,831 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,822 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,100 points
1,055 views
0 votes
1 answer

Using Shapely on AWS Lambda with Python 3

For some reason, the pip install of ...READ MORE

answered Oct 8, 2018 in AWS by Priyaj
• 58,100 points
2,889 views
0 votes
1 answer
0 votes
1 answer
+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,230 points
19,848 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,113 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