Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Deciding on ETL solution

What ETL solution should be used and when between "Amazon Data Pipeline", "Matillion for Redshift" and "Amazon Glue"?

1 Community Answers

Matillion Agent  

Ian Funnell —

Hi Dayna,

Many thanks for this question.

We see these tools fitting into different parts of a data processing solution:

  • AWS Data Pipeline – good for simple data replication tasks.
  • Matillion ETL for Redshift – great for data acquisition, and also for building data transformations via an easy-to-use graphical interface. (Matillion also has replication capabilities in fact)
  • AWS Glue – good for discovering and relationalizing unstructured data before input to Redshift. Please see this document for more context and information.

Best regards,
Ian

Post Your Community Answer

To add an answer please login