Amazon S3 Data Load into Amazon Redshift – S3 Load Component

amazon-s3-composite-screenshots

  • Simple drag-and-drop configuration
  • Supports CSV, delimited, fixed width, JSON and AVRO
  • Schedule data load and transformation and combine with other data, processes and services
  • Use in concert with other components to copy data to S3, then load into Redshift
  • Export data to S3 from Redshift tables

High performance Amazon S3 data load into and out of Amazon Redshift

How to Get Started

 

 

Amazon S3 to Amazon Redshift Load Component

The S3 load component in Matillion ETL for Amazon Redshift provides drag-and-drop data load from Amazon S3 into Amazon Redshift.  Easily load CSV, delimited, fixed width, JSON and AVRO data into Amazon Redshift tables, as standalone jobs or as part of sophisticated integration orchestrations.

 

Features and Benefits

The S3 load component in Matillion ETL for Amazon Redshift delivers fast data load performance, with simple drag-and-drop configuration and is extensible to the most sophisticated data load and transform requirements.

  • Fast and simple – load and transform CSV, fixed width, delimited, JSON or AVRO data into Redshift in a drag-and-drop interface
  • Copy data to S3 from FTP, sFTP, HTTP and HTTPS to S3, then load into Redshift
  • Supports for encrypted data
  • Supports GZIP, LZop and BZip2 compression
  • Standalone data load or sophisticated integration – combine data held in S3 with data from other databases and systems. Integrate with other AWS services including RDS, SQS and SNS
  • Integrates with Lambda, S3 bucket events and SQS for event-based and real-time integration
  • Build, upload and use S3 load manifests, using S3 Manifest Build component, to load a set of files based on a pattern
  • Monitor load status. Comprehensive logging, audit and alerting features
  • S3 Unload feature to export data from Amazon Redshift into S3

 

Useful links:

Want to try S3 Load, S3 Put, S3 Unload and S3 Manifest Builder?

Arrange a free 1-hour demo, or start a free 14-day trial.