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,520 points
82 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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,120 points
88 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
• 3,770 points
118 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,120 points
21 views
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

First Option sm3cmd Use s3cmd s3cmd get s3://AWS_S3_Bucket/dir/file Take a ...READ MORE

answered Aug 29, 2018 in AWS by Priyaj
• 56,120 points
818 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
52 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"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.