Oct 10, 2018

[HDGEM] How to load data into Amazon AWS Redshift

  • Kinesis Firehose/Streams: You can stream data from Kinesis into Redshift as described here.
  • COPY from S3: By far the most common way to load data into Redshift is via COPY command. COPY lets you copy data from S3 into Redshift at scale. Alternatively, you can use 3rd party services or use an open source tool like Embulk. It's worth mentioning that Treasure Datasupports outputting query results into Redshift, allowing the user to join multiple data sources and pre-process them for Redshift.

Posted By Blogger to HDGEM at 3/23/2017 07:01:00 AM