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,560 points
119 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
• 56,520 points
238 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 in AWS by Girija

edited Aug 5 by Kalgi 30 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,090 points
249 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
• 56,520 points
38 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
+3 votes
5 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
• 67,460 points
2,570 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 in AWS by Shashank
• 1,350 points
80 views